Help With Range Names Please
 

Hi,

For a specific project at work, I have been requested to create a
spreadsheet using range names that has 3 identically structured sheets,
one for inputs, one for overrides and one for the actual value to use. I
know this isn't that logical but it has been specified that I do it like
this. What I would like to do is prefix the input range names with FC_
(for financial console), then FCO_ and FCA_ for the overrides and
actual but I don't want to have to type them out 3 times just to add
one letter, especially as there are over 400 range names per sheet. (I
have already entered them on FC_ so maybe I could pastelist the range
names and references and use those somehow??)

Is there a way to create a series of range names using the range names
I have already set in the FC_, so that it copies and applies the
existing range names to the same range on another sheet, but with the
slightly changed prefix?

I have no idea apart from maybe I should use a loop function???

Any help would be greatly appreciated..

Thanks

Adam


--
soteman2005
------------------------------------------------------------------------
soteman2005's Profile: http://www.excelforum.com/member.php...o&userid=29078
View this thread: http://www.excelforum.com/showthread...hreadid=488056

Help With Range Names Please
 

Hi,
You have an answer where you posted at:
http://www.ozgrid.com/forum/showthread.php?t=42907
Dave
soteman2005 Wrote:
Hi,

For a specific project at work, I have been requested to create
spreadsheet using range names that has 3 identically structured sheets
one for inputs, one for overrides and one for the actual value to use.
know this isn't that logical but it has been specified that I do it lik
this. What I would like to do is prefix the input range names with FC
(for financial console), then FCO_ and FCA_ for the overrides an
actual but I don't want to have to type them out 3 times just to ad
one letter, especially as there are over 400 range names per sheet. (
have already entered them on FC_ so maybe I could pastelist the rang
names and references and use those somehow??)

Is there a way to create a series of range names using the range name
I have already set in the FC_, so that it copies and applies th
existing range names to the same range on another sheet, but with th
slightly changed prefix?

I have no idea apart from maybe I should use a loop function???

Any help would be greatly appreciated..

Thanks

Ada

--
Desert Piranh
-----------------------------------------------------------------------
Desert Piranha's Profile: http://www.excelforum.com/member.php...fo&userid=2893
View this thread: http://www.excelforum.com/showthread.php?threadid=48805

Help With Range Names Please
 

i had a little different approach: this will create all the ranges in the
immediate window. copy and paste them in a new module and execute it.it will
create something like this in the immediate window:

ActiveWorkbook.Names.Add Name:="FCO_test", Refersto:="=Sheet2!$A$5:$E$12"

if you want just fco on a certain sheet, just comment out the debug print
line that corresponds.


Sub name_ranges2()
Dim nm As Name
sName = ActiveSheet.Name
For Each nm In ThisWorkbook.Names

Debug.Print "ActiveWorkbook.Names.Add Name:=" & """" & "FCO_" & nm.Name &
"""" & _
", Refersto:=""" & "=" & sName & "!" & Range(nm).Address & """"

Debug.Print "ActiveWorkbook.Names.Add Name:=" & """" & "FCA_" & nm.Name
& """" & _
", Refersto:=""" & "=" & sName & "!" & Range(nm).Address & """"

Next nm
End Sub

--


Gary


"soteman2005"
wrote in message
...

Hi,

For a specific project at work, I have been requested to create a
spreadsheet using range names that has 3 identically structured sheets,
one for inputs, one for overrides and one for the actual value to use. I
know this isn't that logical but it has been specified that I do it like
this. What I would like to do is prefix the input range names with FC_
(for financial console), then FCO_ and FCA_ for the overrides and
actual but I don't want to have to type them out 3 times just to add
one letter, especially as there are over 400 range names per sheet. (I
have already entered them on FC_ so maybe I could pastelist the range
names and references and use those somehow??)

Is there a way to create a series of range names using the range names
I have already set in the FC_, so that it copies and applies the
existing range names to the same range on another sheet, but with the
slightly changed prefix?

I have no idea apart from maybe I should use a loop function???

Any help would be greatly appreciated..

Thanks

Adam


--
soteman2005
------------------------------------------------------------------------
soteman2005's Profile:
http://www.excelforum.com/member.php...o&userid=29078
View this thread: http://www.excelforum.com/showthread...hreadid=488056