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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Selecting Rows using Long Variables
You will get error 23 under the following conditions
1) The row numbers are not defined. Possibly a typo in variable name 2) The Row Numbers are zero or negative 3) the row numbers are larger than the number of rows in your worksheet. for example in excel 2003 65,535 "pallaver" wrote: 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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Selecting Rows using Long Variables
Nevermind, I'm delirious. I had one of the variables in the equation
end up being set to zero, hence the problem. All works fine. On 7¤ë14¤é, ¤È«á2:29, pallaver wrote: 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 |
Reply |
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 |