Help!!
Here is my code
What is meant to happen is that Column E is autofilled until column A is empty! However this is not working column E is Autofilling until the end of the sheet.
Please Login or Register to view this content.
Any help with where I went wrong in my code? PS column A will have a dynamic list, that is each time it could have 1 or 100 rows depending thats why I need E to autofill until A is blank.
Thank you
Last edited by Dnass; 11-22-2013 at 01:54 AM.
Try this…
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
Hi, Dnass,
use Option Explicit at the top of the prodecure, you created a new Variable with lastrow& instead fo using the filled lastrow.
Ciao,
Holger
Use Code-Tags for showing your code: [code] Your Code here [/code]
Please mark your question Solved if there has been offered a solution that works fine for you
Sixthsense this worked perfectly thank you!
Glad it helps you and thanks for the feedback
If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.
Hi, Dnass,
Not according to your original code where the code should look likethis worked perfectly
as the code provided will Autofill in any case.Please Login or Register to view this content.
Holger
Hi Holger,
You're right, this did not work perfectly unfortunantely
I have run across more trouble. Without having to build several macros and have them called for each step I have the following macro. Basically Columns E, F, G H and I will all be autofilled (with different inputs) the autofill should autofill until column A is empty for all. The below code works fine if I have data that goes past cell A2 as soon as I have data that finishes at A2 the macro errors with '1004 instead of exiting the sub.
Any suggestions?Please Login or Register to view this content.
Hi, Dnass,
maybe you should have another look at my posts in this thread for finding out what was changed in order to make the code work without error. You used the very same new Variable as in the opening post - why? The code by Sixthsense works with a With-Statement but neglects the Autofill range to be related to that worksheet.
Regarding your question: put in another if to check if the value of the Variable holding the last filled row in Column A is greater 2 (I choose <=2 here).
This code will check each single column before filling.Please Login or Register to view this content.
You may combine this to read
HTH,Please Login or Register to view this content.
Holger
Holger - excuse me if I had previously seemed ignorant my VBA skills are very very basic and my knowledge is self taught through forums such as this. Your help has been appreciated!! The above code has worked and I have learnt something new! thank you
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks