| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Assigning Variable Range
nrow = 8, so rrow = 5
but the below is not working -- What's wrong? ..... *** code ** nrow = Range("A65536").End(xlUp).Row + 1 rrow = nrow - 3 rrow = CInt(rrow) Range("A" & nrow).Select ActiveCell.FormulaR1C1 = "=SUM(R[-rrow]C:R[-1]C)" <<< PROBLEM Range("A2").EntireRow.Delete Range("A1").Select |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Assigning Variable Range
never mind, just tried the below, which worked..
ActiveCell.FormulaR1C1 = "=SUM(R[-" & rrow & "]C:R[-1]C)" "JMay" wrote: nrow = 8, so rrow = 5 but the below is not working -- What's wrong? .... *** code ** nrow = Range("A65536").End(xlUp).Row + 1 rrow = nrow - 3 rrow = CInt(rrow) Range("A" & nrow).Select ActiveCell.FormulaR1C1 = "=SUM(R[-rrow]C:R[-1]C)" <<< PROBLEM Range("A2").EntireRow.Delete Range("A1").Select |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Problems with assigning range of cells to display chart | Charts and Charting in Excel | |||
| from Range variable | Excel Discussion (Misc queries) | |||
| Extracting unique entries and assigning it to a named range | Excel Discussion (Misc queries) | |||
| Assigning scores to a date range | Excel Worksheet Functions | |||
| Assigning ranges for values (e.g., $1,005 the range is ">$1K to 5K | Excel Worksheet Functions | |||
Linear Mode
