Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Craetion of a Range Name Specific to a single sheet
How is this done?
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Craetion of a Range Name Specific to a single sheet
When naming the range name, precede it with the sheet name, such as
Sheet1!myName or 'Master Sheet1!myName -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "Jim May" wrote in message ... How is this done? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Craetion of a Range Name Specific to a single sheet
Just a typo:
'Master Sheet1!myName should be: 'Master Sheet1'!myName (an additional apostrophe) Bob Phillips wrote: When naming the range name, precede it with the sheet name, such as Sheet1!myName or 'Master Sheet1!myName -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "Jim May" wrote in message ... How is this done? -- Dave Peterson |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Craetion of a Range Name Specific to a single sheet
Thanks Bob (and of course Dave..) -- This helps me to progress
through things - after following your instructions I "look-back" and see that in creating such a sheet-specific range-name - it once created is only visible from the "home" sheetname, and not the others. If In a VBA routine I were to Refer to these rangenames do I need to do anything SPECIAL to Read them (being Sheet Specific)? Thanks for your help.. Jim "Dave Peterson" wrote: Just a typo: 'Master Sheet1!myName should be: 'Master Sheet1'!myName (an additional apostrophe) Bob Phillips wrote: When naming the range name, precede it with the sheet name, such as Sheet1!myName or 'Master Sheet1!myName -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "Jim May" wrote in message ... How is this done? -- Dave Peterson |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Craetion of a Range Name Specific to a single sheet
You can use:
dim myVal1 as variant dim myVal2 as variant myval1 = worksheets("sheet1").range("test1").value myval2 = worksheets("sheet2").range("test1").value Same range name on different sheets--but fully qualified. Jim May wrote: Thanks Bob (and of course Dave..) -- This helps me to progress through things - after following your instructions I "look-back" and see that in creating such a sheet-specific range-name - it once created is only visible from the "home" sheetname, and not the others. If In a VBA routine I were to Refer to these rangenames do I need to do anything SPECIAL to Read them (being Sheet Specific)? Thanks for your help.. Jim "Dave Peterson" wrote: Just a typo: 'Master Sheet1!myName should be: 'Master Sheet1'!myName (an additional apostrophe) Bob Phillips wrote: When naming the range name, precede it with the sheet name, such as Sheet1!myName or 'Master Sheet1!myName -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "Jim May" wrote in message ... How is this done? -- Dave Peterson -- Dave Peterson |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Craetion of a Range Name Specific to a single sheet
Are you saying that If I were to use:
myval1 = range("test1").value myval2 = range("test1").value That there might be a problem with myval1 and myval2 ? Jim "Dave Peterson" wrote: You can use: dim myVal1 as variant dim myVal2 as variant myval1 = worksheets("sheet1").range("test1").value myval2 = worksheets("sheet2").range("test1").value Same range name on different sheets--but fully qualified. Jim May wrote: Thanks Bob (and of course Dave..) -- This helps me to progress through things - after following your instructions I "look-back" and see that in creating such a sheet-specific range-name - it once created is only visible from the "home" sheetname, and not the others. If In a VBA routine I were to Refer to these rangenames do I need to do anything SPECIAL to Read them (being Sheet Specific)? Thanks for your help.. Jim "Dave Peterson" wrote: Just a typo: 'Master Sheet1!myName should be: 'Master Sheet1'!myName (an additional apostrophe) Bob Phillips wrote: When naming the range name, precede it with the sheet name, such as Sheet1!myName or 'Master Sheet1!myName -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "Jim May" wrote in message ... How is this done? -- Dave Peterson -- Dave Peterson |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
Craetion of a Range Name Specific to a single sheet
Take a look at http://xldynamic.com/source/xld.Names.html
-- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "Jim May" wrote in message ... Thanks Bob (and of course Dave..) -- This helps me to progress through things - after following your instructions I "look-back" and see that in creating such a sheet-specific range-name - it once created is only visible from the "home" sheetname, and not the others. If In a VBA routine I were to Refer to these rangenames do I need to do anything SPECIAL to Read them (being Sheet Specific)? Thanks for your help.. Jim "Dave Peterson" wrote: Just a typo: 'Master Sheet1!myName should be: 'Master Sheet1'!myName (an additional apostrophe) Bob Phillips wrote: When naming the range name, precede it with the sheet name, such as Sheet1!myName or 'Master Sheet1!myName -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "Jim May" wrote in message ... How is this done? -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
macro | Excel Discussion (Misc queries) | |||
Range name: Change from sheet specific to global | Excel Discussion (Misc queries) | |||
Match and Sort for two range of data on different worksheets? | New Users to Excel | |||
How to copy records containing a specific date range to new sheet? | Excel Worksheet Functions | |||
Hyperlink to specific sheet in Excel Web File | Links and Linking in Excel |