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.