Forum Discussion
VBA formula help
Hi all Is someone please able to check the Syntax of this macro. For some reason, it does everything but add the formula in C8 and pull it down to the last cell and I can't figure out why. It jus...
You clear the entire worksheet Load File.
So when you cut the (now empty) columns MM:N and insert a column into column A, the entire column A will be empty. That makes the formula pretty useless, if I interpret this correctly.
Apart from that, try this:
Below the line
LastRow = ...
Insert a new line
MsgBox LastRow
Run the macro. What is the value of LastRow?