I am facing problem in macro FillDown method

i have attached code screenshot

What does cell U3 contain?

It has formula sum of Q and T column

check if those failed column contains hyperlink

just select those and right click, remove hyperlink

that code looks fine for VBA

There is no hyperlink the top cell is empty

Did you try to do the Fill Down manually in excel? Maybe, the error is clearer there.

if the values aren’t there, that eill give the robot null as the output which will nut be processed in any expression. Have a check before performing the operation whether values are null, then if they are null they can be assigned default value that won’t hamper the operation. In this case it’s sum, so the null can be replace by 0 first so that it won’t break the operation.