My work computer was recently refreshed, and the new machine that I got is
running Win XP Pro and Office 2003.
Since I received the new computer, I have experienced a problem in opening
Excel files containing macros.  The scenario is, I open an Excel file that

The script runs through all the cells on a sheet looking for an  #na,  if
there is an
#na in all the rows in that column it seeks to hide the row.  The loop works
and there are values in

Excel XP & Win XP
This is a minor problem, I think, but I have never seen this happen before.
When I use any of the following or when I use "application" when using a
worksheet function in VBA, the leading "a" is lower case.  Even when I

In a production workbook (Excel 2002) I have the users enter the effective
date on a user form. I use the IsDate function to be sure it is valid. I
then place the date into a locked cell on a sheet. The IsDate function says
that 10/9/007 is a valid date. But on the sheet Excel ...

I have an excel spreadsheet which is an extract from a text file.
When I convert text to columns any digit ending in a zero(s) has the zero(s)
dropped of however I need to the zero(s) remain because I will remove replace
the decimal with a comma as the digits are real thousands ...

Hello, could someone please advise on how I can make a selection from a
drop-down box that is linked to a Data Validation List in the following
way?
Worksheets named:

Hi, how can avoid people getting into the VBA code of the controls after the
Sheet is done and ready to be in production?
Thanks

just wondering, i have a calendar control that fires on B2. but i notice when stepping through the code after the date is entered, this code fires , even though it exits because the target cell is not being changed.
a lot of processing is done on this sheet and i'm wondering if ...

Trying to find information on dash ports

I run a mile in 8:40 (I5)   in      [m]:ss    format
How do I calculate my speed?

hi,
lets say i have a sheet with like 40 rows in it.  i want to group the rows
by account number.  so i am curious if there is any code i could write to
group the account numbers, with a row between each group, and to see if there

I want to filldown the date shown in cell H1 to column D starting with D2 to
the last row with data in it.  I'm not having any luck.  Can someone help me
with this?  I've looked on previous posts and haven't seen anything that can
help me.  Keep getting errors.

1. I am trying to capture the Exit or LostFocus event of a combobox on a
UserForm.
The Forms controls don't have a handle in vba and, while trying to find the
window 's class using Spy+, it seems like the combobox doesn't have a window

may have asked this before, but can't find it.
is it possible to create a variable from 2 strings and have it return the value?
Simple example, RowColor is Dimmed as Long and has as value of 4
2 strings, one String1 is "Row" the other, String2 is "Color"

I have a named range at the top of a worksheet which resides in a row that
repeats at the top of each page.  I would like to dynamically set the value
of this range which is in this case a cell each time there is a page break.