| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Macro-total a column with different row sizes
Im trying to create a macro and Im having trouble with the last part. I
want to total a column (E) but the number of rows will vary day to day. For example this totaled todays file with 726 rows but tomorrows file might have 800 or 500 rows. How do I account for the various row size? Range("E13").Select Selection.End(xlDown).Select Range("E726").Select Selection.FormulaR1C1 = "=SUM(R[-724]C:R[-1]C)" |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Macro to Inserting Columns and then add column to horizontal total | Excel Discussion (Misc queries) | |||
| copying row/column sizes | Excel Discussion (Misc queries) | |||
| how can i see all column sizes at once not individually? | Excel Discussion (Misc queries) | |||
| How do you get different column sizes in one sheet? Excel 2000 | Excel Discussion (Misc queries) | |||
| excel should let me set row amd column maximum sizes | Excel Discussion (Misc queries) | |||
Threaded Mode
