MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Excel Tips

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.

Excel Copy Subtotals »

February 12, 2002

How to copy only the subtotal rows to a new Excel range.

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.

Text to Columns Using VBA »

February 10, 2002

How to text to columns using VBA.

Summarize Data with Pivot Table »

February 9, 2002

How to summarize data with pivot table.

Setting Cell Font with VBA »

February 8, 2002

How to set cells font with VBA.

Validating Inputbox Entry »

February 7, 2002

How to validate inputbox entry by using macro.

Maximized View in Open »

February 6, 2002

How can I make sure Excel opens my file maximized?

Excel Autoshapes »

February 5, 2002

Free Drawing 98 application from Microsoft to jazz up the drawing toolbar with 139 easy to use symbols for Excel.

Find and Remove Strings »

February 5, 2002

Is there any way I can simply remove certain characters from a text string?