Referring to columns from within a macro
thanks, notes:
Columns: (problem: this eq in row 3 must say 3 here for: AG:AG, else will
say AG3:AG3)
(problem: this cell references columns: AG:AG, as well as: AG3; if you
cut / past over cell AG3 to far right: #REF! stuff happens)
=SUBSTITUTE(SUBSTITUTE(CELL("address",$AG3),"$","" ),ROW(),"")&":"&SUBSTITUTE(SUBSTITUTE(CELL("addres s",$AG3),"$",""),ROW(),"")
NOTE: I use DIM & RANGE reference instead of column / cell references, to
have dynamic reference to changing column/ cell locations.
you must enter DIM & RANGE statements for each of the "made-up" names you
make.
eg missing below: colP1, colP4, dateC2, dateC3..
|