Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Referencing named ranges
I have created some code that counts a range and adds the count total and sum
defines that range as a named range. This part works fine, and I use this code to count several ranges. I then want to put these counts together at the bottom of the worksheet. Again, I can easily reference the range, and it puts the result as a static number, but if the count of the range changes (which it usually does), the numbers at the bottom do not update. I would like it to be able to update whenever the range updates. This the code I am using. The range name is EE_Count_Total. ActiveCell.Formula = Range("=ee_count_total") Can anyone help? Thanks! |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Referencing named ranges
if ee_count_total is the name of a cell that contains the count then:
ActiveCell.Formula = "=ee_count_total" -- Regards, Tom Ogilvy "FinChase" wrote in message ... I have created some code that counts a range and adds the count total and sum defines that range as a named range. This part works fine, and I use this code to count several ranges. I then want to put these counts together at the bottom of the worksheet. Again, I can easily reference the range, and it puts the result as a static number, but if the count of the range changes (which it usually does), the numbers at the bottom do not update. I would like it to be able to update whenever the range updates. This the code I am using. The range name is EE_Count_Total. ActiveCell.Formula = Range("=ee_count_total") Can anyone help? Thanks! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
referencing named ranges in VBA | Excel Discussion (Misc queries) | |||
Referencing Named Ranges using values in a cell | Excel Discussion (Misc queries) | |||
Referencing Named Ranges | Excel Worksheet Functions | |||
INDIRECT and Named Ranges referencing closed workbook | Excel Worksheet Functions | |||
UPDATED - Referencing named Ranges within a Nested IF formula | Excel Worksheet Functions |