Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Selecting Rows using Long Variables
I'm attempting to select rows using predefined long variables.
Rows(CreateStartRow & ":" & CreateEndRow).Select This is what I have, and I thought it was the correct syntax, yet I'm getting an error; "Run time error 13, shape doesn't match" (that error message is translated from Japanese, may not be spot on, but close at least." Where am I going wrong? Currently it's located in a sub routine that's in a different module then the bulk of the macro, but I don't think that matters. Any ideas/ reason why it doesn't work? I'm all ears, thankx. -np |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Selecting All Rows with Certain Data | Excel Discussion (Misc queries) | |||
after selecting 50 rows of a column i can't reference the cells in the rows | New Users to Excel | |||
Selecting Non-Consecutive Variables | Excel Discussion (Misc queries) | |||
selecting certain text in long row of text | Excel Worksheet Functions | |||
Selecting Rows | Excel Worksheet Functions |