PDA

View Full Version : One line of code - what is wrong?



rossmiddleto
03-04-2011, 05:08 AM
For some mysetious reason I am getting an error around the following line of code:


Set workingsrange = Sheets(3).Range(Range("b2"), Range("e9"))


"Application-defined or object-defined error"

Any idea?

rossmiddleto
03-04-2011, 05:52 AM
Solved:

Sheets(3).activate
set workingsrange = Range(Range("b2"), Range("e9"))

GTO
03-04-2011, 07:08 AM
Rather than Select/Activate a sheet, you can set a good solid reference to the range you want. This way, it doesn't matter which sheet happens to be active.

With ThisWorkbook.Worksheets(3)
Set workingsrange = Range(.Range("b2"), .Range("e9"))
End With
Hope that helps,

Mark

Kenneth Hobs
03-04-2011, 07:09 AM
Set workingsrange = Sheets(3).Range(Sheets(3).Range("b2"), Sheets(3).Range("e9"))

mdmackillop
03-04-2011, 01:59 PM
For a bit of variety
Set workingsrange = Sheets(3).Range("b2").Resize(8, 4)