Autofilling the last column

[tom_wain90]

Hi,
I'm new to VBA, self taught from what I've read online and from recording marcos.

I have a spreadsheet that I need to insert a new column between the last column of data and the totals column.
The date row is on row 5 so just find the last column in that row and it gives me that last column.

That bit I can do.

I then need to autofill the formulas across from last column into the new column. I'm struggling to get this bit to work.
Below is what I have that works so far, I'm just now sure how to select the destination of the autofill.

Please Login or Register  to view this content.

[djbomaha]

Hi tom_wain90,

Here is your code modified to do what you are looking for. I deleted the "NewC" variable and just used "LastC+1" instead. To copy the formulas without changing their cell references, I just used the ".formula" convention. In my code, I found the last row with data in the LastC column and then set the range to that lastrow because it runs a little faster. Otherwise, you can just copy column to column, but the code runs a little longer.

Please Login or Register  to view this content.

Hope this helps,

Dan

[tom_wain90]

Hi Dan,
Thanks for your reply, the reason I was opting for Autofill is I'm looking to change the cell reference. There's a monthly figures been shown on a summary page from umpteen worksheets so the cell references allow it to show figures from the relevant month.
I've now got the AutoFill to work for one row but I couldn't get it to work for multiple rows, so using your last row feature I've managed to achieve that.
Here's my code, it looks pretty busy it works haha.

Please Login or Register  to view this content.

Thanks again for your help
Tom