I've recently published a workbook containing vba code to several
users who have different version of both Excel and Windows, both
minimum stanards are Excel 2000 and Windows 2000/NT, yet the
application runs perfectly on some but not others.  The machines that

How do you use Regular expression in excel? For eg: Check a column of
data to see whether are all of them valid email addresses?
Please advise
THanks

I am using an offset formula to bring back data.
I am trying to bring back the cell next to the one that has a label that
matches the file name e.g. the file name is Place and then column a contains
a list of places and column b contains text about those places.

Folks:
I have a bunch of information in a single column of a spread sheet.
I would like to "INVERT" this infomation so that this column becomes a
row.and all information is preserved.

Enter:
=(1.01-1-0.01)
To quote Paul Lynde, "I don't know what you got, but I got a sports
shirt."

Hi, I'm completely new to this board and was wondering if I could
possibly get some help. I'm trying to utilize a cell in which has a
formula in it, however everytime I insert a value to utilize the
formula, it of course.., gets cleared out. Is there anyway to maintain

Can someone tell me if i can still use the form feature to insert rows in a
database in Excel 2007?

I would love to know if there is a website or a community channel where I
can develop worksheet for people who couldnt be bothered doing it them self
They can email the spread sheet to me then i will develop or program it for
their need

I need to save a simple list in an Excel (2003) file as a text file so that
when I open the file in Notepad I get:
"Item 1"
"Item 2"

I use subtotals to help me sum the totals of the differing nominal accounts
in my management accounts.  I collapse the spreadsheet so I can see the
totals of each nominal and then highlight each line so that I can format the
subtotals making them bold and increase the font size ...

Is it possible to print landscape and portrait pages in the same
worksheet?  How?

I have a workbook that has a sheet for each week. I am looking for a way
(formula) that will allow me to create a summary sheet with Column A storing
a valid Sheet Name and Column B DSUM'ing the totals from the sheet listed in
Column A.

hey, i need to make these values in A1:A5
22-000-104-011
22-000-104-012
22-000-104-013

I posted this a long time ago.  I thought I'd try again.  Please see
below:
Jim Shoenfelt    View profile
 More options Oct 14 2000, 3:00 am

I've been trying to do some SQL work in VBA to allow people to change
database fields more easily.
I managed to:
extract the data from the file,