| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Change formulas to variable row in range
Hello,
I have a range that contains formula's like the one below =SUMPRODUCT((LEFT($A$4:$A41,1)="1")*H$4:H41) pulling results from a list The problem I have is that after the macro runs, I want to change the bottom row in the range from 41 to the new bottom which is variable. Is there an easy way to update my formulas with the new bottom number? Your help is appreciated Glen |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| select range and put range address in variable | Excel Programming | |||
| Macro to copy a specified range to a variable range | Excel Programming | |||
| setting a range variable equal to the value of a string variable | Excel Programming | |||
| Excel VBA-Change chart range to variable | Excel Programming | |||
| Problem trying to us a range variable as an array variable | Excel Programming | |||
Threaded Mode
