Hi!
I have an excel sheet with alot of data in it, and i need to add two blank rows between each line of data.
At the moment i have a macro that adds one blank line
Please Login or Register to view this content.
How do I change it so it adds two blank rows?
Last edited by Leith Ross; 05-17-2011 at 03:38 AM. Reason: Added Code Tags
Hello missytordrup,
The easiest way is to use the Resize method for a Range object.
Please Login or Register to view this content.
Sincerely,
Leith Ross
Remember To Do the Following....
1. Use code tags. Place [CODE] before the first line of code and [/CODE] after the last line of code.2. Thank those who have helped you by clicking the Starbelow the post.
3. Please mark your post [SOLVED] if it has been answered satisfactorily.
Old Scottish Proverb...
Luathaid gu deanamh maille! (Rushing causes delays!)
hi, missytordrup, change this line:
to this one:Please Login or Register to view this content.
Please Login or Register to view this content.
Thanks that worked GREAT!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks