MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Formula that changes based on active row

Posted by Jim on May 16, 2001 10:25 AM

I have a formula that resides in column j starting in
cell 29 Example: =sum(C29*E29)/12*G29*B29 I need to
write code (triggered by a command button) that will
copy and paste to next blank down (1 row per command
button click) and read the next row as =sum(C30*E30)
/12*G30*B30. Any help would be greatly appreciated.

Posted by Kevin James on May 16, 2001 10:37 AM


If you've been thinking of upgrading to Excel2000, you're prayer is answered. Excel2000 does that automatically.


Posted by Brian P on May 16, 2001 12:51 PM

you looking for something like this

Sub copy()
ActiveCell.copy ActiveCell.Offset(1, 0)
End Sub

Brian P