kylefoley76
Well-known Member
- Joined
- Mar 1, 2010
- Messages
- 1,553
can't r1c1 achieve the same thing as
INDIRECT(ADDRESS(ROW()-2,COLUMN())
for example,
=substitute(INDIRECT(ADDRESS(ROW()-2,COLUMN()),"x","y")
can't that be rewritten with r1c1, especially in vba
INDIRECT(ADDRESS(ROW()-2,COLUMN())
for example,
=substitute(INDIRECT(ADDRESS(ROW()-2,COLUMN()),"x","y")
can't that be rewritten with r1c1, especially in vba