Cell Reference in Excel?

[MrClinker]

I want to select a specific cell in Excel(using range().select). The reference of that cell is stored into another cell in text format.

How can I tell Visual Basic to use the text that is inside that cell to positionate there?

Example:

In A3 i have "f5". If i write range("a3&quot.select, the cursor goes to A3, I want the cursor to go to f5 instead.

Thank you very much

Gerardo.

 

[SkipVought]

Hi,

range([a3].address).select

Skip,
Skip@TheOfficeExperts.com

http://www.TheOfficeExperts.com

 

[SkipVought]

but consider NOT selecting unless is it absolutely necessary.

See faq707-4105 How Can I Make My Code Run Faster?

Skip,
Skip@TheOfficeExperts.com

http://www.TheOfficeExperts.com

 

[MrClinker]

This is not working.

 

[Bowers74]

Sorry to jump in Skip,

But your code would only select cell A3 (because that is the address).

MrClinker Try this:

range([a3]).select

But you should read Skips FAQ.

And Mine! faq707-4090 ;-)







Peace!

Mike

Never say Never!!!
Nothing is impossible!!!