Forum Discussion
Auto Fill Error when output data are less than 1
Hi, I have been trying to use below AutoFill code, but I am getting an error when data is less than 1. Is there a way for get away with this error: Range("E2").Select Selection.AutoFill Dest...
Hi. Thanks for the file.
I assume you have created this macro with the macro recorder, there are a lot of steps in it which are not needed.
Since I sill don't know what you are actually trying to do, I can't help you.
Please explain what the macro is supposed to do
I assume you have created this macro with the macro recorder, there are a lot of steps in it which are not needed.
Since I sill don't know what you are actually trying to do, I can't help you.
Please explain what the macro is supposed to do
PascalKTeam Hi Pascal, There are some sensitive things for which I can't disclose the data. I gave you a better portion of coding already. What I was trying to reach was to avoid the Autofill data error when the data is less than 1.
However, I have achieved the same by using IF condition. I know there are coding made by recording the macro but what is the harm in it.
Please see attached video and file. Is this what you need?
PascalKTeam Hey @Pascal,
Thank you but I would urge that let's finish this here, as I have already resolved my issues.Thank you for your efforts.
