View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
pallaver pallaver is offline
external usenet poster
 
Posts: 62
Default 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