Hi...Thanks for responding....
An example that comes to mind is "Range("A1").Select". If I try to change
it to "Range(Cells(1, 1)).Select", Excel will immediately go into a "Debug"
state. I have a macro now that could use a variable such as
"Range(Cells(RowNo,ColNo)).Select" as well as the "Current Active Cell". I
fairly new using VBA macros but a former programmer.
Thanks again...

"Shane Devenshire" wrote:

Hi,

You can use A1 notation instead of R1C1 notation anytime you want. So I'm
not sure what you want - please give us an example of what you want.


--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"RidgeView" wrote:

There must be an easy way to make cell "numeric row"/"numeric column" (R1C1
notation) to "Alpha Row"/Numeric Column" (e.g. "B3") format. There are macro
statements that require the latter and it would be nice to use a variable for
those cell locations especially when the active cell is required.
Thanks.....