Select a column using it's number
 

If I have a cells row and column numbers. I.e. G4 had a row of 4 and a
column of 7 can I get the value of that cell using these values or do I have
to convert the 7 into the letter G and joun it the the number 4 in a string
first?

for Example:

str2 = "G" + trim(str$(Target.Row)

strValue = Range(str2).value

Select a column using it's number
 

strValue = Cells(4,7).value

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Keith" wrote in message
...
If I have a cells row and column numbers. I.e. G4 had a row of 4 and a
column of 7 can I get the value of that cell using these values or do I
have
to convert the 7 into the letter G and joun it the the number 4 in a
string
first?

for Example:

str2 = "G" + trim(str$(Target.Row)

strValue = Range(str2).value