I have recorded and example macro for a spreadsheet. How would I edit this macro so that it will autofil/copy/paste text one column at a time (eg. first for column B then C then D then all the way to column CF). I need to do it one at a time as each column will have 50,000 rows of data.
Please Login or Register to view this content.
Is the code applying a formula in row 2 as well?
There is usually a better approach than using autofill.
Dom
Last edited by Domski; 03-18-2010 at 08:33 AM. Reason: Silly question
"May the fleas of a thousand camels infest the crotch of the person who screws up your day and may their arms be too short to scratch..."
Use code tags when posting your VBA code: [code] Your code here [/code]
Remember, saying thanks only takes a second or two. Click the little star to give some Rep if you think an answer deserves it.
I want the formula in B2 to be copied down to B50000, then copy the formula C2 down to C50000 etc... to CFOriginally Posted by Domski
The copy/paste portion that relates to B3:B50000 is there to keep the formula in B2.
Try:
Please Login or Register to view this content.
Dom
Thanks a million, that works perfectly.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks