View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Chip Pearson Chip Pearson is offline
external usenet poster
 
Posts: 7,247
Default I will never, ever get this correct ...

Larry,

Get rid of the last & " and the spaces within the quotes. E.g.,

Range("A" & new_start & ":D" & new_rows ).Select


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
www.cpearson.com


"Larry Levinson" wrote in message
...
Range("A" & new_start & " :D " & new_rows & ").Select

ok, where are the `"' and `&' in the wrong places? I promise to try to
get it correct from now on. sigh ....


Larry Levinson
Talking up to the vocal ...
LLevinson*Bloomberg.net
(remove the star etc ....)