View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
RidgeView RidgeView is offline
external usenet poster
 
Posts: 21
Default Converting RIC1 code to letter Column/Numeric Row

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.....