Excel Tips
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.
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.
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.