My problem is I want to use VBA to close 2 workbooks if they're open and do
nothing if they're not open.
Put it another way, if I put
Workbooks("book1.csv").Close SaveChanges:=False

Using Excel 2002 --
Is there a simple way to copy the contents of the cells along a row so
that they will be appear as entries in cells running down a column?
Is it possible to do the reverse as well?

Where do you chage the font default for a comment box.  Each time I insert a
cooment box into excel, it defaults to a font size of 8 and I have to change
it to read it.  Where is the setting to change this to a different font
size.

Hi everyone.  Using E02 on XP.  I am trying to work some formulas and I have
the general idea what I need to do.
I have a date of birth [DOB] and date of hire [DOH].  I need to calculate
Eligibility to Participate by calculating [Age] and [Service] and then: If

Hello, I'd be grateful if anyone has any ideas on the following error
messages:
On starting Excel (2000 v9.0.6926 SP-3) I get the message: Compile
error in hidden module: mdlInitialize

I want to create an exceel worksheet where the borders are protected from
copy/paste and drag/drop but the users can still type in data.
Thanks

When you resize your scroll bar on the task bar, what is the name of the
thing you click to do this?

I need to create a macro and assign it a macro button at the top of the
worksheet (with the text Enter Hours) .  This macro needs to select the cells
in Colum E (called Hours) enabling me to enter hours in, pressing Enter after
each figure.

I've been manipulating a fair amount of data.  In some instances I have been
cutting some data out of a worksheet and pasting it into another one.  Just
when I think I have all the data out of the central worksheet, I find some
more data that is quite a few cell rows down.

I want to add the sales (column B) of the people in column A.
A            B
James     23
Randy     43

I have a workbook that has around 18 worksheets in it. Is there a macro
when clicking on the print button that only the pages with data entered
prints out.
Right now I have to print each page one at a time or print the whole

Were using Excel 2003 and ran into the end of colums at IV. Besides
upgrading to Office 2007 is there way to extend or add-in more columns.
Thanks,
BobV

I would like a formula to determine if someone is 70 1/2 at the end of
a year. I used =DATEDIF(DateofBirth,EndofYear­,"y") but the result is
only accurate to a whole year, for example DateofBirth = 6/30/1937 and
EndofYear = 12/31/2007 gives 70.0 rather than 70.5. How can I do this?

I have imported data from an accounting program and the date format is
20070101 for January 1, 2007. I have looked at various sites that would use
Left(),Mid(),Right() to break the numbers and then put them back into
2007/01/01 but was wondering if anyone had a simpler solution.

I have 3 columns of alphanumeric data.  The first represents a list of
partial license numbers with only numeric data. The 2nd and 3rd
represent complete license numbers with alphanumeric data. I want to
find matches for as many digits of the partial license numbers (in the