Get rid of default range references in macro

[LorneG]

I am trying to work through a very simple formula that is repetitive for some large spreadsheets we are modifying. This was a snap in Lotus but with Excel I am suddenly macro illiterate but would still like to avoid carpal tunnel syndrome.

I created the macro to sub total rows "up" in a cell and then copy the formula across columns to te end of the column data. Backspace and then enter.

Then I need to move down to the next cell and repeat.(this part has to be manual process)
Now, it appears in excel that rather than let the macro execute from wherever the cursor is moved to, that it defines a range for the macro to use. Whyit defaults like this seems odd. None-the-less I have seen similar questions but need som direct help on this one.
Below is current code created by excel.

Sub Sum_up_paste_over()
'
' Sum_up_paste_over Macro
' Macro recorded 08.26.2002 by Lorne Ganten
'
' Keyboard Shortcut: Ctrl+l
'
Range("E779").Select
ActiveCell.FormulaR1C1 = "=SUM(R[-15]C:R[-1]C)"
Range("E779").Select
Selection.Copy
Range("F779:BG779").Select
ActiveSheet.Paste
End Sub

Appreciate whatever help you can provide.

 

[zacemmel]

Selection.formula = "insert formula here"

Use this instead of Range... etc...

Hope this helps

 

[LorneG]

Thanks for the info.
As I am a newbie to VLB where can I find the formulas to use for Lotus "endup" , "end over", "up1", etc and copy/paste equivalents