Hello,
I've tried finding an answer but have been unsuccessful so far - I need someone to spell this out for me I think!
In the Macro I'm trying to put together, I want to enter a formula into cell B2 (so far so good) and I want to copy the formula down as far as the last non-blank cell in column A.
So if I were simply in a spreadsheet, I would double click on the drag down square in the bottom right hand corner of the cell selected. That is all I'm trying to do - but within a macro.
Hope that's making some sense and fingers crossed somebody can help. Apologies if this has been answered before.
Cheers
James
I've tried finding an answer but have been unsuccessful so far - I need someone to spell this out for me I think!
In the Macro I'm trying to put together, I want to enter a formula into cell B2 (so far so good) and I want to copy the formula down as far as the last non-blank cell in column A.
So if I were simply in a spreadsheet, I would double click on the drag down square in the bottom right hand corner of the cell selected. That is all I'm trying to do - but within a macro.
Hope that's making some sense and fingers crossed somebody can help. Apologies if this has been answered before.
Cheers
James