Some time we want to hide a certain Excel Worksheet from view, and it’s a common practice to use select the Worksheet, go to menu Format > Sheet > Hide. Using the method explained above is right, but unfortunately, others people can easily unhide the Worksheet using the same method, only this time, instead of [...]

A few weeks ago I received this question from someone called LS: Hi I want to write a macro that counts the following – Number of cells with formula – Number of Rows with formula – Number of Columns with formula Please let me know if there is a way of doing it in Excel [...]

If you read my latest update on how we can get position of last row containing data, then most probably you already have a glimpse on how we perform the same task with last column containing data in Excel. The VBA code is the exact replica of the code to get the last row, only [...]