Goto

[Yellowdude]

Ive got a cell reference written in Cell A1 and I want a macro to select this cell?
Can any one help with the code?

 

[waggy30]

to select a cell use

Range("A1").Select

Why couldn't you have just recorded the macro?

 

[Yellowdude]

I phrased that wrongly.
I want to copy the value in the cell and select the value in the cell.

Eg In A1 there is 'C5' I want XL to select C5

 

[KniteMare]

On 2002-03-07 08:08, Yellowdude wrote:
I phrased that wrongly.
I want to copy the value in the cell and select the value in the cell.

Eg In A1 there is 'C5' I want XL to select C5

The following assumes you have a button named CommandButton1 and this button is on the same sheet as the cell being referenced.


If the value in A1 is a cell refeerence this will select it.
That is if A1 has C5 in it the routine will select cell C5.
Hope that is what your looking to do.

Option Explicit
Dim x As String
Sub CommandButton1_Click()
x = Range("A1").Value
Range(x).Select

End Sub
This message was edited by KniteMare on 2002-03-07 08:23