Hi...strange question...I have a macro that I created that inserts a row, adds a formula. Now I need to copy the formula down to the last row. (You know, like when you double click in the corner of a cell and it copies the formula to the last row with data in the adjoining column).
When I double click while recording my macro it just references the actual column and row number, but it won't aways be the same as the spreadsheet grows daily. So I need a "copy to last row" formula for the macro. But the last row will change everytime I run it.
I hope this makes sense. I am new to this macro stuff!! But trying to learn!
When I double click while recording my macro it just references the actual column and row number, but it won't aways be the same as the spreadsheet grows daily. So I need a "copy to last row" formula for the macro. But the last row will change everytime I run it.
I hope this makes sense. I am new to this macro stuff!! But trying to learn!