ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   I will never, ever get this correct ... (https://www.excelbanter.com/excel-programming/275879-re-i-will-never-ever-get-correct.html)

Dan E[_2_]

I will never, ever get this correct ...
 
Larry,

Give this a try.

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

changed 2 things:
took out the spaces in " :D "
removed the final (& " )

Dan E

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





All times are GMT +1. The time now is 05:33 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com