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 ....) |
All times are GMT +1. The time now is 07:27 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com