Excel 2002 (10.2) - Using the LEFT function in a macro

[Paddington1881]

Hi all

I've been tinkering with ways to include the LEFT function in a macro, but without success.

I'm trying to isolate the first 2 characters in an a cell, and then use that to go to a separate worksheet with the same 2 character name. For instance:

Cell A1 is "AD1234". I want the macro to recognise the "AD" part and go to a worksheet called "AD" and do some stuff (lookups etc).

I thought it would be quite easy but I'm absolutely stumped. I'm going through Excel VBA For Dummies now, but I get the feeling I'm a level below dummy cos I'm just not getting it. Is what I'm trying to do possible?

Any pointers much appreciated, as always.

Thanks
Darren

 

[DonkeyOte]

Sheets(Left(cells(1,1),2)).select

 

[VoG]

Sub test()
Dim MyName As String
MyName = Left(Sheets("Sheet3").Range("A1").Value, 2)
Sheets(MyName).Select
End Sub

BUT you do not need to select this sheet to work with it.

 

[Paddington1881]

VOG II - you are a star. That works great.

lasw10 - thanks for your reply but I couldn't get your code to work for me.

Best regards to you both

Darren