I'm very new to VBA, so please excuse my ignorance.
I have recorded a Macro to AutoFill a row in my Excel spreadsheet. The VBA code is very simple and looks like this:
I thought I would simply be able to click on another row and re-use the Macro, but this doesn't seem to work, as I get the following error message: AutoFill method of Range class failed.
What do I need to change in my code, so that it will work in any row I choose?