Hello to everyone,
I would like to look for the last used cell in column 1, then grab L4 and auto-fill it up to the last used cell in column 1. Then auto-fill the range down to the last used row.
In the attachment, AQ1 is the last used cell, so I would like to auto-fill L4 to AQ4. Then grab L4:AQ4 and auto-fill it down to row 41.
Hopefully someone can help with the above as I've been struggling for a day editing other macros I've found online with no success.
Thank you
Try on a copy of your data
Please Login or Register to view this content.
If my solution worked (or not) please let me know. If your question is answered then please remember to mark it solved
Computers are like air conditioners. They work fine until you start opening windows. ~Author Unknown
Hi WasWodge,
The code works perfectly, thank you! I was wondering if you could help me with a slight issue I am having. In case I have other data below the MIN and MAX, the auto-fill moves after the MIN and MAX.
Is it possible to also give a quick explanation of each line in the code as I'd really like to understand how it works?
Thank you!
See below
Or I suppose another option is to changePlease Login or Register to view this content.
toPlease Login or Register to view this content.
But please note you will have to clear the contents each time before running.Please Login or Register to view this content.
Last edited by WasWodge; 03-31-2013 at 08:14 AM. Reason: Colour
Worked like a charm!
Clearing the contents each time before running the code seems obvious but obviously I didn't think of it before you mentioned it! Thank you very much for the help and the explanation WasWodge. Really appreciated!
Just to point out the clearing of data only applies if you are using the line below as it needs the empty spaces to work
If you are using something like the code below then it doesn't matter (unless you have less columns) as it doesn't need the empty spaces, because it looks for the last row with data and not the first row with data.Please Login or Register to view this content.
Please Login or Register to view this content.
Last edited by WasWodge; 03-31-2013 at 08:03 PM. Reason: added a space
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks