LinkBack URL
About LinkBacks
Hi,
The below look has to go through 30,000 lines and takes ages. Is there a more efficent way to achive the same outcome. All it does is concatenates columns 6 & 7 together.
Please Login or Register to view this content.
Hi,
The below look has to go through 30,000 lines and takes ages. Is there a more efficent way to achive the same outcome. All it does is concatenates columns 6 & 7 together.
Please Login or Register to view this content.
It loops 30,000 times. Worse is it may do infinite loop.
Please Login or Register to view this content.
If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
Mark your thread as Solved
If the suggestion helps you, then Click *below to Add Reputation
SS,
The OP does not use column A or D. Columns F-H
Oops... Thanks for the correctionOriginally Posted by AB33
I just tested it by creating a small data and forgot to change it to actual references
Here is the corrected version of code
Please Login or Register to view this content.
Thanks what if I wanted a space between the two values
Why not just use a standard function in Excel rather than VBA
i.e. in H2 copied down
Formula:
Please Login or Register to view this content.
Or if you need the macro equivalent
Avoid loops at all costs since they just take too long when compared to using standard functionality.Please Login or Register to view this content.
Last edited by Richard Buttrey; 06-26-2014 at 08:55 AM.
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star iconbelow the post.
Add a space within the & like the below
Please Login or Register to view this content.
Hi thats what I thought but it did not work
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks