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()<\/p>\n
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 changed<\/p>\n
Along with ADDRESS, ROW and COLUMN and some text tricks like SEARCH, LEFT, LEN, RIGHT, etc, you can do a lot.<\/p>\n
You see INDIRECT does a simple job<\/p>\n
So…<\/p>\n
If you do<\/p>\n
It gives you the value in G4<\/p>\n Notice that “G4” has the double-quotations, means<\/p>\n <\/p>\n Will give you the value in cell G8 if total number of S1 to S4 is 8<\/p>\n <\/p>\n This is powerful, and this is why I was able to do most of the tricks, like<\/p>\n iframe in Excel (XLiFrame), <\/a>Rotate table using 1 formula<\/a>, and Insert Blank rows into table using functions<\/a><\/p>\n Plus more<\/p>\n <\/p>\n","protected":false},"excerpt":{"rendered":" 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…<\/p>\n=INDIRECT(\"G4\")<\/code><\/p>\n=INDIRECT(\"G\"&SUM(S1:S4))<\/code><\/p>\n