I've always used A1 notation in my formulas as well as VBA. When I need to
select a range from anything higher than column Z, I generally use VBA to
convert to a multi-letter column ID.

I'm working in someone else's workbook, and want to avoid VBA/macros (and
might as well learn something new). The existing formula is:

=INDIRECT("RawOut!" & CHAR(InfoLists!D19+1+64) & "781")

and now that the data has hit more than 26 columns, it is throwing a
reference error. Is there a simple replacement to reference any column's
alpha ID, even the 2-digit IDs? If not, what would be the appropriate way to
replicate the above statement with R1C1 notation (I'm assuming I can use
R1C1 in only 3 cells and leave the rest of the workbook in A1 notation,
there are hundreds of formulas I don't want to change)

Thanks!
Keith

--
The enclosed questions or comments are entirely mine and don't represent the
thoughts, views, or policy of my employer. Any errors or omissions are my
own.