Range selection in a sheet module

R

raj

Hello, please help me if you can.

I am trying to make a simple range selection from inside a
worksheet module, for example:

Range(strRange).End(xlToLeft).Select

or even something as simple as:

ActiveSheet.Range("A5").Select

And I get "Select method of range class failed." error.
How can I correct this?

Your example code to fix mine would be greatly
appreciated. Thanks in advance.
 
D

Don Guillett

I just did both of these without a problem
Sub selcel()
'ActiveSheet.Range("A5").Select
strRange = "$IV$1"
Range(strRange).End(xlToLeft).Select
End Sub

Try leaving xl and coming back or re-boot
 
Top