Tag Archives: excel macro

VBA Delete Excel Rows Based on Certain Date

Posted on January 31, 2009 by Admin

Let say I have a bunch of formatted data in my Excel sheet, and in Column A I have a dates. Then I wanna filter all the data base on certain date, for example 1 Jan 2009, and delete all … Continue reading →

Posted in Cells and Range, Workbook and Worksheet | Tagged , , , , , , , | 62 Comments

Finding Cell with Minimum/Maximum Value in Active Worksheet

Posted on October 4, 2008 by Admin

Let say we want to find position of cell containing the minimum/maximum value in current/active Excel worksheet, and then after we found the cell, we will change the cell format to make it stand out before other cells. The logic … Continue reading →

Posted in Excel VBA Function, Workbook and Worksheet | Tagged , , , , , , , , , , , , , , , , , , | 10 Comments

How To Hide an Excel Worksheet

Posted on September 24, 2008 by Admin

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 … Continue reading →

Posted in Workbook and Worksheet | Tagged , , , , , , , , , , , , , , , , , , , , , , , , | 7 Comments