July 8, 2002
Use Cells(Row, Column).Name = "MyRange" to simplify naming a range.
July 7, 2002
Use Cells(Row, Column) instead of Range() when looping through several columns.
July 6, 2002
Every time that I copy data from another application and paste it into Excel, the data is inexplicably being parsed into two columns. What is going on?
July 5, 2002
For a SUMIF or COUNTIF formula with 2 conditions, you need to use an array formula.
July 2, 2002
Excel makes it very easy to get a default chart up and running.
June 25, 2002
Excel to run a macro every time a value changes in the Excel spreadsheet.
June 18, 2002
Duplicate worksheets by giving incremental names.
June 11, 2002
I need to import a file daily. I'd like to add the file each day to an existing Excel workbook and have the worksheet named for the d/m/y.
June 4, 2002
I have imported a file into Excel. The zip code is broken into 2 cells. The 5 digit part of the zip code is in column E, the 4 digit part of the zip code is in column F. I need to join them into a single cell.
June 4, 2002
How to quickly navigate to any worksheet.
May 28, 2002
Search a column and highlight red the cells that contain today's date.
May 25, 2002
How to increment a number by one each time the user form is opened.