Thread
:
Naming Ranges with code
View Single Post
#
2
Posted to microsoft.public.excel.programming
Don Guillett
external usenet poster
Posts: 10,124
Naming Ranges with code
More info. However, probably best to have the name defined by the offset
formula
insertnamedefinename itin the refers to box type
=offset($C$1,1,0,counta($C:$C)-1,1)
Now when you add/subtract a row of info the range will auto adjust.
For the data, user can input or use a macro using inputbox
--
Don Guillett
Microsoft MVP Excel
SalesAid Software
"Les" wrote in message
...
Hello all, i have a report that has rows added to it and it has both a
columnm that is a range name, so the new cell has to be added to the range
and secondly within that range the cell has it's own name dependant on
what
the user puts in.
C D E
Desc. Code P/O
Bonnet Hood "HoodPo"Range name
Bumper(Font) BF "BFPo"
Bumper(Rear) BR "BRPo"
Front end FRT "FRTPo"
IMC-SAS IMC "IMCPo"
New Part Test "TestPo"-- New range Name for cell.
The old PORange in column "E" (E1:E5) must expand to (E1:E6)
The "code" will be put in by the user.
--
Les
Reply With Quote
Don Guillett
View Public Profile
Find all posts by Don Guillett