| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro creates formula with $ absolute. I want to drop the $
I've got this
LastRow = Cells(Rows.Count, "H").End(xlUp).Row Set rng = Range("H2:H" & LastRow) ActiveCell.Formula = "=SUBTOTAL(9," & rng.Address & ")" Which gives me this on the spreadsheet: =SUBTOTAL(9,$H$2:$H$1122) But I want this: =SUBTOTAL(9,H2:H1122) How do I stop the $? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| F4 no longer automatically creates absolute reference | Excel Worksheet Functions | |||
| Macro creates two graphs instead of one? | Excel Programming | |||
| VBA Code, My excel macro creates the charts on top of each other | Excel Programming | |||
| How to Rename a Blank Sheet that a macro Creates | Excel Programming | |||
| Macro that creates a directory but... | Excel Programming | |||
Threaded Mode
