If a user choses a range in the Name Box is there a way to catch that range
in a variable after selected?
Thank you,
Steven

hopefully someone can help!
Im trying to return a sumif using two constants, Desc & Month
Act Name   Month
Column A  Column B Column E

Thanks,
George

I have a user entering data into a cell then that data is used through out
the page, but if the user does not enter any data into a cell all the other
cells get ### entered onto them.
The user does not need to enter data into every cell, only the ones he

I have two workbooks. On "list.xls" I have a spare parts list, and I want to
search for different items form another workbook (Search.xls) using VLOOKUP
in VBA.
Actually I have this code in "search.xls", but I get "Syntax error":

Is there a way to select a sheet and delete all objects using a macro?
Thank you,
Steven

Now can I make a cell one color if the cell has no value.
I know how to make it a color if it have a value 0 through 9 but if nothing
then I need to show the cell still needs input by changing the cell color.
Thnak you

I have a UserForm that adds and edits data on a worksheet.  To load the
UserForm the user Double Clicks a cell that contains a reference number, the
macro searchs for the reference number in another worksheet and loads the
UserForm with the associated data.  I have to keep the ...

How would I change the color of a block of cells with one click of the mouse
and then the next click a different color?
Example cells
on my excel 2003 page 7,8,9/DEF make a block. I need the first click in the

I am trying to figure out a way to let users "sign" an spreadsheet for
approval. We could accept them typing there initials in a cell, but we need
to authenticate that it was that person.  Is there any way to do this?  
Thanks!

I'm trying to create a small script reading a Excel sheet and creating a new
sheet.
But I want to get only rows without a date.
I tryed something like this:  (SALIDA is my date)

I am using excel 2003.
I will like to know how i can use the mid/left/right function to separate
the address I want column A&B to be separated by state, city, & zip. results
for column A should be right after colum A & results for coulm B should be

a cell is dim as social security. I want to copy that to a variable.
What do I dim the variable as?
If I use string, then when I copy it to a different cell dim as social
security it shows up as #######.

I have
D4-D10
E4-E10
F4-F10

Hi
In cells A5:A105 I have e-mail addresses that are populated from a look up
table.  I need to send the section C4:J105 to all the e-mail addresses but
the addresses are often duplicated in the range A5:A105 and I only want the