Please I am looking for a good reference to learn how to dynamically create a
custom toolbar.
thanks.  

I have a program that finds rolling 1 - 30 aged data.
The heading has   1  -  30
above that I would like to put the dates, such as 1/18 - 2/17
The below subroutine does that except the dates show the year also.

When resizing a range, excel doesn't seem to acknowledge the new size
In this example rect is increased by 1 row and 1 column.
yet when the number of rows is asked for in the msgbox in replies with
8.

I'm hoping this is simple one for one of you guru's. I'm looking for a
macro that will search multiple columns and clear any cell that has
today's date or older in it. Format of the date is 02-1-06 and
02-31-06. In other words, the day is not always two digits.

I have officially arrived at a dead end.  I know what I want to do, but
for one, I don't know if it's possible, and for two, even if it is
have no idea how to do!  I would much appreciate some help on the
matter.

I am an Excel novice so please be patient!
My problem is this-
I have a drop down list set up in D2 in worksheet 1 which references a list
of customers contained in column A in worksheet 2. When the selection is

I'm attempting the following macro which saves the file to a network
drive (with no errors)
  ChDir "J:\"
  ActiveWorkbook.SaveAs Filename:="J:\User.xls", _

I have a spreadsheet that allows me to place a word in one cell and i
searches for that word in several columns. When it finds a match i
highlight the cell with the matched word. What I would like, rathe
than highlight the cell, is to have the speadsheet copy the matche

The code below is supposed to select all the none duplicate records
from a given range, but for some strange reason I do get duplicates but
only when the first cell in the range is identical to the second cell
in the range, if the first and second cells within the range are not

Dear All,
I have a list of 100 names , and i want to make sure that those names are in
another list of 1500 name ..
how can I do this ?

I have a fleet of fork trucks where I work and I am trying to design a
spredsheet/database so that I have the complete list of trucks and each
one has a service interval. These vary from truck to truck ie: 6 months,
12 months etc.

Hope you can help, need to move a value in one cell to another only IF the
first cell is not empty.  
In a function it would be:
in cell B2 - - - - >  =IF(C2="","",C2)

I have a spreadsheet with code that is password protected.
The prev. owner is no longer available for questions.  Do I have any
recourse to get at the module?
Thank you.

First off, platform info - WinXP Pro2002, Office 2003.
I have a spreadsheet with 288 small pictures in it.  When I copy any of the
first 187 picutes to the clipboard, I see a fully rendered image on the
clipboard.  Image 188 is only partially rendered.  Images 189 and on only

I am creating a two page device status report in Excel. VBA code will be
run to populate the fields of the report and save a the report as a file
- one for each device listed in the database (approx. 1000). It is
necessary for me to print each of these reports for our contractors,