Hi!
With all that is going on in the world I thought now is the best time to learn and am teaching myself VBA from scratch with the help of online tutorials.
That said, I've come up with a code, but it isn't quite performing the way I want and I cannot figure out why.
I have a spreadsheet that I input figures into on a weekly basis and then would normally copy formulas down from a previous row to update (another workbook looks for the latest figure in various columns which is why these are copied on a weekly basis and not pre-filled).
The code is as follows:
However, if these columns have no data in row 21 they do not work and I get the following error:
Run-time error '1004':
Application-defined or object-defined error
If row 21 does have a values, they work as intended.
If anyone can point me in the right direction so that it is just pasting the formulas from row 20 without the need to have data in row 21 this would be greatly appreciated!
Completely appreciate that I may also be running this process in a manner that is quite basic, but just started teaching myself today.
Many thanks,
Richard
Bookmarks