Hi,
I need help on creating a macro that adds a column before the last available column and copy the formula from the left column. Please see example worksheet. What I want is to add a new column after Z and before AA. And copy the formula from Z4,Z5,Z6 to the new column cells. See attached sample file.
Thanks!
Why ???????
Simply insert a column and copy Z4,Z5,Z6 to new AA column ???
Want this automated through macro without having to add manually.
Use the macro recorder then?
Moved to correct VBA forum
See next code
Please Login or Register to view this content.
- Battle without fear gives no glory - Just try
Thanks! This works. But, only issue is it is also copying the content of the entire column. Would be great if only the formula is copied and the input value of the cell is not. Is this possible?
Not sure to get it right.
Using your file a column is added before last column AB: New column is AA.
In this new column there is only formulas.
See your file attached
Thanks again! See example, inserting the column is also adding the column. Of course since the macro is copying the entire column so along with the formula if there are any data they are getting added too.
Last edited by maxi0009in; 03-22-2020 at 11:00 PM.
You're welcome
If all is OK then close the thread
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks