Hello,
Please look at this code and tell me where I'm going wrong, the meat of the code is a recorded macros, what I wish to do is loop the macros to the end of the sheet and have it say 'done' when it is finished doing the loop. Here is the code:
End Sub
Please Login or Register to view this content.
Any assistance would be awesome.
CheerZ!
Wyldjokre69
Last edited by wyldjokre69; 09-01-2013 at 07:18 PM.
Could you attach a copy of the workbook ? If there is confidential data feel free to remove it and replace it with dummy text. You have a lot of "Selection" and Its hard to see the whole.
Thanks
Maybe ...
Please Login or Register to view this content.
Last edited by shg; 09-01-2013 at 08:04 PM. Reason: simplify ...
Entia non sunt multiplicanda sine necessitate
Here is a sample worksheet with macros attached to worksheet. Hope this helps. The original is quite long, but I've added the necessary information to see if the loop can be added to the macros.
CheerZ!
Wyldjokre69
Hello Shg,
Thank you for the code, but when I tried it, this part of the code is causing a problem:
I selected all of the H column, which is where I'm trying to make my corrections and the error: Run-time error '450': Wrong number of arguments or invalid property assignmentPlease Login or Register to view this content.
CheerZ!
Wyldjokre69
Gosh, and here I thought testing was overrated ...
Please Login or Register to view this content.
Hey Shg,
Genius, friggin' genius. Thank you. It did the trick.
CheerZ!
Aaron
Friggin' welcome, friggin.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks