Excel Tips
How to Filter Out Duplicate Data »
February 17, 2002
I work closely with comparative lists and need to learn how to either identify duplicate cells or even better filter out duplicates.
Keeping Excel from Changing Data to Dates »
February 16, 2002
Excel changes entered data to dates automatically!
Freeze Panes for Select Rows and Columns »
February 15, 2002
Can you freeze rows and columns at the same time?
Rounding Time to a Specific Value »
February 14, 2002
How to round a time value to a specific value.
Use MsgBox to Execute Optional User Choice »
February 13, 2002
I would like something which the user gets asked a question and yes leads to macro and no does nothing.
Protecting Specified Data Using VBA »
February 12, 2002
How to use workbook events to enable range selection.
Hiding a Range Depending Upon User Selection »
February 11, 2002
If a control checkbox is not checked then I would like to hide specific rows and columns automatically with VBA.