Hi people at Excel forum

I have just begun using VBA for Excel, so I am a newbie :) I hop
somebody can help me with the following problem:

Each of the cells from A1 until A10 contains different kind of text.
Cell B1 contains an integer between 1 and 10.
In cell B2 I want the same text as in the cell, which is pointed out b
the integer value in cell B1. For example: If B1 contains the intege
value 5, then B2 should automatically obtain the text from cell A5.

What VBA code is appropriate for cell B2?

Best regards,

Eri

--
Vestergaar
-----------------------------------------------------------------------
Vestergaard's Profile: http://www.excelforum.com/member.php...nfo&userid=795
View this thread: http://www.excelforum.com/showthread.php?threadid=48849