Selecting Rows using Long Variables

  • Thread starter Thread starter pallaver
  • Start date Start date
P

pallaver

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VBA selction of rows using a variable 5
Summing rows using formulas with variables 1
select multiple rows using variables 6
Insert blanks, but populate new blank rows in one column 6
selecting rows using a variable 3
Variable upper and Lower row selection 2
Using variable to select rows 1
Using variables in Rows.Select 5

Back
Top