Retrieving VLookup Values
 

Hi there.

I'm creating an excel workbook and I want to create a macro which moves
to the correct worksheet. It retrieves this correct worksheet from a
VLookup formula, linked to a drop down box.

Example:

On the DataSheet the values a

1 | Worksheet name
2 | Other worksheet name

and on the page with the macro and form the formula is
=VLOOKUP(D2,DataSheet!B2:D5,2) (D2 is a drop down box from which the
worksheets are chosen)

Any ideas how I can get VB to read the VLookup to get the worksheet
name?

Thanks.


--
xander1987
------------------------------------------------------------------------
xander1987's Profile: http://www.excelforum.com/member.php...o&userid=27236
View this thread: http://www.excelforum.com/showthread...hreadid=467453

Retrieving VLookup Values
 

Man I feel like a noob now. Sorry.

For future reference, it was the .Value I needed =/

It's been a while since I've worked with Macros so... yeah... that's my
excuse =)


--
xander1987
------------------------------------------------------------------------
xander1987's Profile: http://www.excelforum.com/member.php...o&userid=27236
View this thread: http://www.excelforum.com/showthread...hreadid=467453