referencing with variables
 

I have variable with column "A" and integer variable with value 1 and I
want to read value from that cell. How could I do that?


--
mpele
------------------------------------------------------------------------
mpele's Profile: http://www.excelforum.com/member.php...o&userid=31808
View this thread: http://www.excelforum.com/showthread...hreadid=520022

referencing with variables
 

Sub test()

Dim sColumn As String
Dim iRow As Integer

sColumn = "A"
iRow = 10

MsgBox Range(sColumn & iRow)

End Sub


RBS

"mpele" wrote in
message ...

I have variable with column "A" and integer variable with value 1 and I
want to read value from that cell. How could I do that?


--
mpele
------------------------------------------------------------------------
mpele's Profile:
http://www.excelforum.com/member.php...o&userid=31808
View this thread: http://www.excelforum.com/showthread...hreadid=520022