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"))
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)
Powered by vBulletin® Version 4.2.5 Copyright © 2024 vBulletin Solutions Inc. All rights reserved.