Using cell reference but then select that cells value on ano

[Jazzmanstereo]

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]

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*