Autofill try catch

[haziqbmz (Muhammad Haziq Bin Mohamad Zaiz)]

Hi, I have the following error when trying to autofill:

“Auto Fill: Could not auto-fill range. Select only cells that contain data to use as a source for filling down the other cells.”

I understand it’s because there is nothing to autofill, but how do I ignore the error and continue? I tried try catch but not sure how to make it work, please assist.

Sorry I’m new to all this, thank you

[Parvathy (PS Parvathy)]

Hi @haziqbmz

Check the below thread

Auto Fill: Could not auto-fill range. Select only cells that contain data to use as a source for filling down the other cells

@Fresher You just need to give the first cell which contains the formula and the auto fill will fill till the end cheers

Regards

[haziqbmz (Muhammad Haziq Bin Mohamad Zaiz)]

Hi @Parvathy

The autofill is specified to autofill 2 rows as the formulas is slightly different for row AA2 and row AA3.

Regards