Excel Tips
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.
Find the Elapsed Time Between Two Time Entries »
October 22, 2001
I need to find the elapsed time between two moments. Each moment has a date and a time. I need to know how much time was elapsed, in minutes or in hours and minutes.
Number Format to Hide Zeroes »
October 22, 2001
When I copy cells to a another page, then I link them, I get zeroes in the empty cells were there is no data.
October 21, 2001
Let's say you have a thousand-line table. With clever subtotaling, you create a 30-line summary. You want to copy this summary onto a worksheet containing other information.
October 18, 2001
How can I open a workbook in VBA choosing from a list?