V
Vestergaard
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
I have just begun using VBA for Excel, so I am a newbie
![Smile :) :)](/styles/default/custom/smilies/smile.gif)
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