ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Cannot .select (https://www.excelbanter.com/excel-programming/394835-cannot-select.html)

JeffMelton

Cannot .select
 
I've just started getting this problem and I don't have a clue what
the issue is, maybe someone here knows whats going on.

I'm trying something like this, which is a very simple code, in fact
it was created my the macro recorder while I was shifting some stuff
around. In fact I've had it happen with hand written code as well,
not that it matters because its the same code.

Rows("2:2").Select
Range("C2").Activate
Selection.Insert Shift:=xlDown



I'm getting select method of Range class failed #1004, does anyone
know whats going on?


JeffMelton

Cannot .select
 
Sorted, I'm an idiot. I had the code inside a worksheet that used
another sheet.



All times are GMT +1. The time now is 03:06 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com