| Home |
| Search |
| Today's Posts |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA Formula with variable s/b simple
Thanks Jim - It worked PERFECT
I new I was close! "Jim Thomlinson" wrote: Range("C" & LASTROW).formula = "=SUM(C1:C" & lastrow - 1 & ")" -- HTH... Jim Thomlinson "Bricktop" wrote: I am trying to sum a column in Excel in my macro. This is what I have so far Range("C" & LASTROW).formula = "=SUM(Range("C1:C" & lastrow - 1"))" I've tried several scenerios and just can't figure it out Any help would be greatly appreciated. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how to set up a simple variable in Excel, but cell location independent | New Users to Excel | |||
| how to set up a simple variable in Excel, but cell location independent | Excel Worksheet Functions | |||
| variable cell referencing for simple data points | Excel Programming | |||
| Simple Variable Question | Excel Programming | |||
| Simple problem refering to variable in For ... Next loop ... | Excel Programming | |||
Threaded Mode
