Cannot get this macro to work right - it copies cell Bx, then waits for you
to hit enter to paste?

I need to copy all hte formulas in last row into the next row, columns B to
AH.

"FSt1" wrote:

hi
sub copyformula()
Range("B1").End(xlDown).Copy
Range("B1").End(xlDown).Offset(1, 0).PasteSpecial xlPasteAll
End Sub

regards
FSt1

"Pete" wrote:

Hi - really need a macro that allows users to go to the next blank row
(column B) and copy formulas into next row - where they enter new data.
Without a macro, I can use CTRL+END...
Any advice would be greatly appreciated, thanks in advance!