Range selection in a sheet module

  • Thread starter Thread starter raj
  • Start date Start date
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.
 
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
 
Back
Top