Hi Guys
I have been trying to copy four columns to the last row. I can get one row but despite all my trials I can't get four. I expect its simple. I have uploaded an Excel file with two sheets. What I have and what I want. The actual sheets varies in length and this will be party of a larger Macro.
Thanks in advance.
Mark
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.
try this if columns are adjacent.. If workbook contains huge data don`t forget insert ActiveWorkbook.Save code to take effect of formulae..
In following code it is assumed that Col A contains max row otherwise use ApplicationMax Worksheet function..
Please Login or Register to view this content.
Last edited by mangesh.mehendale; 08-08-2015 at 08:46 AM.
Don`t care, take care...
Regards,
Mangesh
Hi AlphaFrog & Mangesh Mehendale
Thank you for your help. Both solutions work almost instantly. I know I have said it before but every time I am helped I am so appreciative and aware of how considerate people all around the world are. Thenk you very much. I will now use and study both so i can understand them and use them again.
Mark
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks