| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Insert SUM Formula using VBA (Range Varies)
I have a macro that pulls a lot of text files and creates one Excel file. I
want the macro to insert SUM formulas into various places in the Excel file. Could someone give me the VBA code to enter a SUM formula that calculates the sum of a range that starts in row 8 and ends in 1 row up from where I am putting the formula. Example - if I am putting the formula in cell B36 I want the formula to SUM the range B8:B35. The starting row B8 will always be the same but the ending row B35 will vary. Thanks, Bill Horton |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Can a range be copied if it varies in size? | Excel Discussion (Misc queries) | |||
| Setting a range that varies | Excel Programming | |||
| Sum of a range that varies | Excel Discussion (Misc queries) | |||
| Macro to insert a formula based on a range | Excel Discussion (Misc queries) | |||
| How to insert formula to a range of cells from VBA? | Excel Programming | |||
Threaded Mode
