| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Vba Formula To Include Activesheet Name
Thanks in advanceHow can I get the following formula to work by making it
reference the name of the active sheet? Where lr and br are variables. Cells(5, 4).Formula = "=SUMPRODUCT((ActiveSheet!$R$" & lr & ":$R$" & br & "=$B$14)*(ActiveSheet!$I$" & lr & ":$I$" & br & "0))" Thanks in advance |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| include sheet name in formula | Excel Discussion (Misc queries) | |||
| Use a password in VBA ActiveSheet.protect & ActiveSheet.unprotect? | Excel Programming | |||
| Copying new activesheet after other activesheet is hidden? | Excel Programming | |||
| Sum if formula to include value in col Q when no value in col P for that row | Excel Discussion (Misc queries) | |||
| Modify A Formula To Include AND | Excel Worksheet Functions | |||
Threaded Mode
