Goto

Yellowdude · Mar 7th, 2002, 08:52 AM

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 · Mar 7th, 2002, 08:57 AM

to select a cell use

Range("A1").Select

Why couldn't you have just recorded the macro?

Yellowdude · Mar 7th, 2002, 09:08 AM

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 · Mar 7th, 2002, 09:21 AM

Quote:

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 ]

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

Mar 7th, 2002, 08:52 AM	#1
Yellowdude New Member Join Date: Mar 2002 Posts: 20	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?

Mar 7th, 2002, 08:57 AM	#2
waggy30 New Member Join Date: Mar 2002 Location: England Posts: 46	to select a cell use Range("A1").Select Why couldn't you have just recorded the macro?

Mar 7th, 2002, 09:08 AM	#3
Yellowdude New Member Join Date: Mar 2002 Posts: 20	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