Hey,
I've got a list of about 62,000 values and I need to copy and add them to a row beneath. This needs to be done 15 times for each value.
I've achieved this with the code below, but at a rough estimation it will take about 8 or 9 hours to complete. I'm just wondering if there is a quicker and more efficient way to do it by any chance?
Thanks for the help!
Please Login or Register to view this content.
Josh.
This should be faster.
If you don't require the formula in the inserted rows, the bolded line of code inserts the value instead of the formula. Otherwise, delete it and uncomment the formula line.
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.
That seemed to do the trick. Thanks man, it's very much appreciated
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks