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...
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.
- OK that's great. Sometimes a workaround is not a bad solution 🙂 If it works, it works