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!
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!