April 2015 – XLf(x)s

Why I ran from =INDIRECT() function

Posted on April 6, 2015December 24, 2016 by ANmar

I think if there is a single function that would be a huge threat to VBA and macros from user perspective, it would be INDIRECT() Yes, it wasn’t long enough before I got introduced to OFFSET() back in 1998, and was using it a lot and in my classes, yet once I found INDIRECT, things […]

Get column name (columnname as A,B,C, etc) as input inside cell

Posted on April 6, 2015December 5, 2018 by ANmar

Excel already has the formula ROW() =Row() Which as we may already know will give us the number of the row we are in, if you add no parameters However, the COLUMN() is kind of tricky Because of the fact that cell addresses (or references) are based on the old style of R1C1 =Column()