Using cell reference but then select that cells value on ano

Jazzmanstereo · Apr 9th, 2002, 09:04 AM

Hi, its me again.

What i need to know is if there is a way to use a value from one page but select that cells value on another page.

What i have (from the good peeps on this board) is....

Range([B1].Value).Select

But now i want to select that cell reference (which is within B1) on another page.

Is there a way? please help me

Chris Davison · Apr 10th, 2002, 01:58 PM

no replies, so I'll stick my oar in.....

if this were formula-based, I'd suggest using =INDIRECT

but it looks VBA based, so I'll timidly suggest something similar :

try INDIRECT, after thoroughly researching the syntax

*blowing smoke rings*

Apr 10th, 2002, 01:58 PM	#2
Chris Davison MrExcel MVP Join Date: Feb 2002 Location: Millbank, London, UK Posts: 1,790	no replies, so I'll stick my oar in..... if this were formula-based, I'd suggest using =INDIRECT but it looks VBA based, so I'll timidly suggest something similar : try INDIRECT, after thoroughly researching the syntax blowing smoke rings __________________ :: Pharma Z - Family drugstore ::

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Apr 9th, 2002, 09:04 AM	#1
Jazzmanstereo New Member Join Date: Apr 2002 Location: England Posts: 10	Hi, its me again. What i need to know is if there is a way to use a value from one page but select that cells value on another page. What i have (from the good peeps on this board) is.... Range([B1].Value).Select But now i want to select that cell reference (which is within B1) on another page. Is there a way? please help me