Hi,
I am new VB coding and want to do the following:

Range("B12").Value = myVariable

But ... where the cloumn heading is a variable also



I have been able to write it as:

cellRef = columnVar + "12"
Range("cellRef").Value = myVariable

Is it possible to parse the line 'Range("B12").Value = myVariable' so
that B is a variable also??

Thanks for any ideas help


---
Message posted from http://www.ExcelForum.com/