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