I'm in VBA, creating spreadsheets.

Have fallen into the habit of making the created spreadsheet's column format
"R1C1". Much more convenient for iterating through columns and rows....

But when I create a .Range and then take .Address, it comes back in "$A$1:$B$1"
format.

Am I getting the .Address the wrong way?

Or do I need to be able to translate the address to RowColumn format?
--
PeteCresswell