| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
cell name - macro
Hello,
I wrote this macro to name a cell: caddress = ActiveCell.Address cursheetname = ActiveSheet.Name ActiveSheet.Names.Add Name:="LAST", RefersToR1C1:="=cursheetname!caddress" it does not work. anybody can help ? thanks. == this also does not work: ActiveSheet.Names.Add Name:="LAST", RefersToR1C1:="=cursheetname!address(ReferenceStyl e:=xlR1C1)" |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
cell name - macro
try this simple line
activecell.name="Last" -- Don Guillett SalesAid Software "alex" wrote in message ... Hello, I wrote this macro to name a cell: caddress = ActiveCell.Address cursheetname = ActiveSheet.Name ActiveSheet.Names.Add Name:="LAST", RefersToR1C1:="=cursheetname!caddress" it does not work. anybody can help ? thanks. == this also does not work: ActiveSheet.Names.Add Name:="LAST", RefersToR1C1:="=cursheetname!address(ReferenceStyl e:=xlR1C1)" |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| 'IF' Macro to insert cell contents to alternate cell if cell not e | Excel Worksheet Functions | |||
| using a cell value to control a counter inside a macro and displaying macro value | Excel Worksheet Functions | |||
| If cell is empty then run macro otherwise skip this macro | Excel Programming | |||
| macro to run a separate macro dependent on value in cell | Excel Programming | |||
| Question: Cell formula or macro to write result of one cell to another cell | Excel Programming | |||
Hybrid Mode
