MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Excel Tips

Sorting IP Addresses »

November 1, 2001

How to properly sort IP addresses in a column.

Add Row While Copying And Manipulating Data »

November 1, 2001

Do you have a macro that can add rows at the bottom or at cell pointer, then copy from the previous row and insert the data in the new row?

Referencing a Worksheet with Object Variable »

October 30, 2001

Use Set to create an Object Variable instead of a regular variable when referencing worksheets.

Average Using Pivot Table »

October 30, 2001

I use Excel to monitor my glucose levels several times a day. After a month of readings, I want to see an Excel table showing the average glucose level in each hour of the day.

Round Time to the Nearest Quarter Hour »

October 29, 2001

I need to enter a series of time values in military time. Then, I need to total them up and round to the nearest quarter hour.

Make the Header Row Stay Visible as You Scroll Through Data »

October 28, 2001

I have a very long spreadsheet with many columns of numbers. I am looking for a way to make the header row "float" near the top of the data pane while scrolling down for each reference.

Count Text or Numeric Entries with COUNTA instead of COUNT »

October 27, 2001

Is there a function which will count the number of text entries in the column?

Find the Longest Content in Cells »

October 26, 2001

I want to write an formula which calculates the max of length of the column values.

Highlight The Active Cell »

October 25, 2001

I am working on a event code for highlighting the active cell, basically show change the background color of the active cell.

Fill in the Next Empty Row in the Worksheet »

October 24, 2001

I have a worksheet where I input some values. Upon clicking a macro button, I want the values or its calculated results to be appended to a different sheet or file.

Delete a Worksheet in a Macro Without Delete Confirmation »

October 23, 2001

Is there a way in VBA to remove a worksheet which will bypass the "The selected sheets will be permanently deleted. Click OK" prompt?

Add New Months To Excel Chart »

October 23, 2001

A common problem faced by Excel users is they have a chart of time-series data and need to extend the chart with new figures. Editing all of the data series for a number of charts can be time consuming.