Hi, everyone -
I know it's been a long time, but I thought I'd jump back in with a
doozie that I've been struggling with. I  've included a small bit of
code below that is a small part of a much larger strip. Basically, what

I am looking for code that will check a range of cells to see if they
contain any data. If they do, then I know the sheet has been used before
and it is not the first time it is being used.

I have an excel worksheet that has a column that contains values that
look like this "BD345". I need to extract the numbers by using a macro
since I have about 15000 entries. For example in a cell where the value
is BD345 I want to activate the macro  and then get the 345 in the ...

I created an Excel file and used Active X to create some drop downs to
select several different functions related to graphing. It works fine on
a couple of PC's but on the 3rd all I get is an outline of the drop down
with a red X. I uninstalled/reinstalled Office 2003 and all of ...

I've bumped into an interesting situation. Upon creating and running a macro
(below) to programmtically change PPT-embedded Excel sheets, it runs MUCH
slower (~100x slower) than if I run the macro from pure Excel. I can only
think it has to do with bad Excel referencing (e.g.

In Cell B4 I have the string      Array_Test.xls
     When I double-Click on it (B4)
Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As
Boolean)

I wanted to use Distinct Command thro MS query (excel)for filtering
duplication from other database. PLs confirm how i can use & syntax for the
same.
I have tried "SELECT DISTINCT FIELD1,FIELD2,..... FROM TABLE"

I'm trying to write a macro that will compare the contents of two
nearby cells to see if they are identical. The cells all contain the
names of creative placements, so they are not numerical values.
I'm thinking something like,

I am a beginner with macros, so please bear with me.  I need to write a
simple macro for a sheet in order to simplify a repetitive task.  I have
2 columns, each with a dollar amount that gets added to a new cell each
day by one user.  At another point in the day, a different user

I'm trying to use the keydown event to make the down arrow key change
the selected item in a listbox. The focus is in a texbox, and I've put
my code into the textbox_keydown event. The listbox selection is
changed, but then the focus is moved from the textbox to the next

The data entry form adds the line of data to the bottom of the database
worksheet.  What I'm wondering is if the data entry form can add it to
the top, so that the first record entry is at the bottom, and the most
recent listed at the top.

We use a standard corporate Excel 2003 install. I just finished a project
and wanted to make sure users were accessing the file from our network (not
a local copy) and added the code below. Most users haven't had any problems,
but on roll-out (after the pilot went fine) we are ...

Mr Phelps, my problem should you choose to accept:
Have an address column field in an excel file.
The  address field could contain just an address
or an address + Address 2 (i.e. Suite, PO box, Floor, Etc)

Hello, I have a workbook that contains several macros and many formulas. It
works beautifully until I try to print or do a print preview. Then it locks
up excel and I have to restart. Any ideas about what is causing this?
Thanks!

How do you tell if the active file workbook protect is activated?  For Sheet
protect test I have used:
If ActiveSheet.ProtectContents = True Then  ............
For the Workbook I tried: