Macro Help Required - Run script until no more data in column. Possible loop needed?
Hi,
I have a simple Button that when pressed will run the following command:
The problem I am facing is, the list is column A will vary in length ever day, therfore I do not want to have to edit my code daily. Can someone help me re-code this so it stops when it gets to the last cell that contains data in column A. I know I can simple change Range("B:B") but I am then left with date that needs to be deleted.
Please Login or Register to view this content.
Any help would be much appreciated.
Dave
Last edited by djm601; 02-28-2012 at 07:59 AM. Reason: my question was answered
What is your macro trying to achieve?
If I have helped, Don't forget to add to my reputation (click on the star below the post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Use code tags when posting your VBA code: [code] Your code here [/code]
Hi thanks,
I have a list of Order Numbers in column A
BDG-00000001
BDG-00000002
BDG-00000003
When i press the button, I would like it to simply add the following to the ID numbers in coulmn B as a seperate list or even alter column A.
'BDG-00000001',
'BDG-00000002',
'BDG-00000003',
I have achieved this by recording a macro however the list of ID numbners that will be in the spreadsheet will very, e.g. today there are 50 but tomorrow there could be 100
Can you alter my original marco so that the script is not fixed to Range("B2:B53") as shown in my example, and it will apply this formula to all cells in the column
Hope this makes sense,
cheers,
Dave
Please take a moment to read the forum rules and amend your original post to include code tags.
Dom3. Use code tags around code. Posting code without them makes your code hard to read and difficult to be copied for testing. Select your code and click the [#] button at the top of the post window (if you are editing an existing post, press Go Advanced to see the [#] button).
"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.
Sorry i cant reply to you till you put the code tags.
All you need is this codeYou can then include the code to copy pastespecial values if required.Please Login or Register to view this content.
Re: Macro Help Required - Run script until no more data in column. Possible loop need
Excellent! Thank you, this was bugging me for an hour!
Your code worked fist time, cheers.
Dave
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks