Want to copy the block of non empty rows that start at A26. Number of rows after A26 is variable.
In the example sheet want to copy everything in A26:A30.
Thanks
Want to copy the block of non empty rows that start at A26. Number of rows after A26 is variable.
In the example sheet want to copy everything in A26:A30.
Thanks
Please Login or Register to view this content.
Surround your VBA code with CODE tags e.g.;
[CODE]your VBA code here[/CODE]
The # button in the forum editor will apply CODE tags around your selected text.
Hi potga,
This will copy the dynamic range to the clipboard (you didn't say where you wanted the range copied to):
Regards,Please Login or Register to view this content.
Robert
____________________________________________
Please ensure you mark your thread as Solved once it is. Click here to see how
If this post helps, please don't forget to say thanks by clicking the star icon in the bottom left-hand corner of my post
Thanks
Just what I was after.
On behalf of AlphaFrog and myself, you're welcome. Thanks also for the rep and marking the thread as solved
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks