Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
using macro to name a dynamic cell
Thanks David. This looks like it would work. I have incorporated it. The
intermediate window indicates that "thisrow" and "thiscolumn" are working. But the cell is not getting renamed. I've compared it to naming commands that have specific cells and I can not see the difference. Any ideas? Thanks, Papa "David" wrote: Hi Papa, This assumes you have located on the cell you want to name "AbsSum" and it first deletes any name "AbsSum", then names the cell you are located on "AbsName". Sub Macro1() ActiveWorkbook.Names("AbsSum").Delete ThisRow = ActiveCell.Row ThisColumn = ActiveCell.Column ActiveWorkbook.Names.Add Name:="AbsSum", RefersToR1C1:="=Sheet1!R" & (ThisRow) & "C" & (ThisColumn) End Sub "Papa Jonah" wrote: I am automating a process for doing some calculations and "grading". I have code that sums a column when data is input. However I want that sum to feed another calculation in another location. Because the position of the cell with the sum changes with the size of the data set, I can not refer to it by address. I have looked at naming the cell, but the name appears to be attached to an address. Currently, the cell with the sum is attached to cell b1 in a defined range called "absum". Any ideas would be much appreciated. TIA |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
select last cell in a dynamic list using a macro | Excel Discussion (Misc queries) | |||
Help with copying dynamic column selected based on remote cell value and dynamic formula fill | Charts and Charting in Excel | |||
Macro - Dynamic cell selection | Excel Discussion (Misc queries) | |||
Goto a dynamic cell address within a macro | Excel Discussion (Misc queries) | |||
Dynamic Filename From Macro | Excel Programming |