Simple VBA code to select cells

[normpam]

This code works fine:
Range("E3").Select
Range("E3", Range("E3").Offset(0, 6)).Select

I have always been able to do virtually the same thing using 'ActiveCell' instead of a specific cell, such as E3 in this case, but it just won't work anymore. I keep getting the following error:
Run-time error '1004'
Method Range of object_Global Failed

Has something changed in VBA? I also note that the F8 function key no longer works.....
Thanks!

 

[Joe4]

It would need to look like this:

   Range(Range("E3"), Range("E3").Offset(0, 6)).Select

or more simply, like this:

   Range("E3").Resize(1, 7).Select

 

[normpam]

This code works fine:
Range("E3").Select
Range("E3", Range("E3").Offset(0, 6)).Select

I have always been able to do virtually the same thing using 'ActiveCell' instead of a specific cell, such as E3 in this case, but it just won't work anymore. I keep getting the following error:
Run-time error '1004'
Method Range of object_Global Failed

Has something changed in VBA? I also note that the F8 function key no longer works.....
Thanks!

Think I got it... just need to take out the second 'Range' keyword and it works.

 

[Kenneth Hobson]

Range(ActiveCell) alone is a problem. As for F8 extended selection, maybe you need to reboot or restart Excel? I guess there might be a case where it may not function as usual depending on what your macro or Excel state is at at the time.

Sub Test()
  Range([E3], [E3].Offset(, 6)).Select
End Sub

Sub Test2()
  Range("E3").Select
  Range(ActiveCell, ActiveCell.Offset(0, 6)).Select
End Sub

Sub Test3()
  MsgBox Range(ActiveCell).Address  'error
End Sub

 

[Fluff]

This

Range("E3", Range("E3").Offset(0, 6)).Select

Works quite happily for me. Is the sheet protected?
Also F8 in the VBE still steps through the code.

 

[Joe4]

Works quite happily for me. Is the sheet protected?
Also F8 in the VBE still steps through the code.

You are correct. I went back and tried it, and it works for me too.

Might be an issue of protection, as you said.