Extract current (Active) workbook name
I need that more often than I thought It is basically extract the full workbook name that we are in, with no folders, and with...
Week number to Month number
Now we need to convert week number to month number This is exactly the same as week number to date (reverse weeknum) So, when the...
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...
Week number to Sunday date – Weeknum reverse
This was a request from one of my work managers She wanted to convert a week number she got in a column into thier dates...
Fx to cut long column into two columns
Convert one long column into two This set of formulas will get the items after row 45 (for example) from column A into the column...
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...