Why I ran from =INDIRECT() function
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()...
Get column name (columnname as A,B,C, etc) as input inside cell
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...