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() 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 […]

iframe in Excel (XLiFrame)

This is the iframe in Excel, if you are familiar with the HTML concept of iframe, you will understand this one right away, it is basically the same project as HoScrollArea but with vertical scroll too. Formulas used to bring actual data is: =IF(OFFSET(INDIRECT(“‘”&$F$2&”‘!$A$1″),$D7-1,$D$6-6+COLUMN())=””,””,OFFSET(INDIRECT(“‘”&$F$2&”‘!$A$1”),$D7-1,$D$6-6+COLUMN())) While formula used to bring header labels:

Rotate table using 1 formula

Rotating table (Transpose) using functions so that the table is updated once the source table is updated. Also can be used as automatically rotating tables with variable number of rows and columns Sheet name can be used inside formula so that you can have multiple tables from different sheets to be rotate it into one […]

Insert Blank rows into table using functions

Here you will see how to work with functions to insert a blank row every certain number of rows in a table using a blank sheet to copy all values of that table into the new sheet Then using Copy > Paste Special to make them constants The new thing is that this is all […]