Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Naming a cell from VB
Hello there, I want to set up a procedure to insert somes names into a
workbook that refer to another workbook (because the formulas in Excel get WAY too long otherwise) and am using the following code (which of course does not work): ActiveWorkbook.Names.Add Name:="dens", _ RefersToR1C1:="=[Tbl.cost.xls]tbl.cost!R" & namerow & "C" & namecol IT'S THE "RefersTo" THAT IT DOES NOT LIKE. The following code is what I get from recording a macro, but I can't use it because the cell locations may change from time to time: ActiveWorkbook.Names.Add Name:="tbl.cost", _ RefersToR1C1:="=[Tbl.cost.xls]tbl.cost!R3C2:R228C63" Can someone steer me in the right direction please? Regards, Brett |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Naming a cell from VB
It worked fine in my little test.
What do you have in namecol and namerow at that point? -- __________________________________ HTH Bob "Brettjg" wrote in message ... Hello there, I want to set up a procedure to insert somes names into a workbook that refer to another workbook (because the formulas in Excel get WAY too long otherwise) and am using the following code (which of course does not work): ActiveWorkbook.Names.Add Name:="dens", _ RefersToR1C1:="=[Tbl.cost.xls]tbl.cost!R" & namerow & "C" & namecol IT'S THE "RefersTo" THAT IT DOES NOT LIKE. The following code is what I get from recording a macro, but I can't use it because the cell locations may change from time to time: ActiveWorkbook.Names.Add Name:="tbl.cost", _ RefersToR1C1:="=[Tbl.cost.xls]tbl.cost!R3C2:R228C63" Can someone steer me in the right direction please? Regards, Brett |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Naming a cell from VB
Hi Bob, there was garbage in there, and I assumed there wasn't. Ooops! Thank
for the tip. Brett "Bob Phillips" wrote: It worked fine in my little test. What do you have in namecol and namerow at that point? -- __________________________________ HTH Bob "Brettjg" wrote in message ... Hello there, I want to set up a procedure to insert somes names into a workbook that refer to another workbook (because the formulas in Excel get WAY too long otherwise) and am using the following code (which of course does not work): ActiveWorkbook.Names.Add Name:="dens", _ RefersToR1C1:="=[Tbl.cost.xls]tbl.cost!R" & namerow & "C" & namecol IT'S THE "RefersTo" THAT IT DOES NOT LIKE. The following code is what I get from recording a macro, but I can't use it because the cell locations may change from time to time: ActiveWorkbook.Names.Add Name:="tbl.cost", _ RefersToR1C1:="=[Tbl.cost.xls]tbl.cost!R3C2:R228C63" Can someone steer me in the right direction please? Regards, Brett |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Naming a cell from VB
Sometimes you just need that other view <g
-- __________________________________ HTH Bob "Brettjg" wrote in message ... Hi Bob, there was garbage in there, and I assumed there wasn't. Ooops! Thank for the tip. Brett "Bob Phillips" wrote: It worked fine in my little test. What do you have in namecol and namerow at that point? -- __________________________________ HTH Bob "Brettjg" wrote in message ... Hello there, I want to set up a procedure to insert somes names into a workbook that refer to another workbook (because the formulas in Excel get WAY too long otherwise) and am using the following code (which of course does not work): ActiveWorkbook.Names.Add Name:="dens", _ RefersToR1C1:="=[Tbl.cost.xls]tbl.cost!R" & namerow & "C" & namecol IT'S THE "RefersTo" THAT IT DOES NOT LIKE. The following code is what I get from recording a macro, but I can't use it because the cell locations may change from time to time: ActiveWorkbook.Names.Add Name:="tbl.cost", _ RefersToR1C1:="=[Tbl.cost.xls]tbl.cost!R3C2:R228C63" Can someone steer me in the right direction please? Regards, Brett |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Cell and tab naming | Excel Discussion (Misc queries) | |||
tab naming from a set cell | Excel Discussion (Misc queries) | |||
Naming a cell | Excel Worksheet Functions | |||
What is wrong with naming a cell as c? | Excel Discussion (Misc queries) | |||
Naming a cell | Excel Worksheet Functions |