Hi, I don't know how to use an if structure with arange:
rngEndCell is a range
If rngEndCell = Nothing Then
ssss = Cells(47, columna).Address(False, False)

I need to have a function in Eexcxel that will Automatically capture the save
date (like in Word) for version control. Format would be MMMM/DD/YYYY HH:MM
and would like it to be in footer. Please indicate the steps to program it
into excel as well.

I'm trying to write vlookup that will lookup cells in a different
worksheet.  However, there are two matches on the other worksheet.  How
can I get it to sum up those two matches and then put it as my value.
I'm looking for something like this but I don't know how to get it to

Hi, is there somehow tell VB that 0<>Empty??????
I have problems with this part of my code
blablabla
If  Cells(aa, columna) = c   Then

I have a form I've created in Excel 2003 that used ADO to connect an Access
database.
After distributing it, one person has come back saying they get a message  
"can't find project or library" and nothing runs.  

Is it possible to use the spinner to set the numeric portion of a cell
reference, eg the 21 in the cell range "A21"?
The resulting cell range, "A21", is to be used in another formula...like this:
Cell "B10" = "A21"

I have a column of alpha numeric strings and I want excel to be able to find
which strings appear most frequently.  The column is several hundred cells/
rows long and each cell contains as many as 15 or so strings.  Is there a way
to do this as an easily repeatable process in ...

I want to be able to do the following:
1. Click in a cell inside a named range ("DNS_zones_selection") and have "x"
entered into the clicked cell.
2. If the cell already has an entry, it should be erased.

Ok here is what I have:
Columns with several rows of names followed by several rows of numbers,
I need to cut the numbers out, insert a new column and paste them in
the new column. I have tried several things but can't quite get it. I

I'd like to build a macro that sums up four colums in a worksheet.  The
workbook is generated automatically by a database program.  Once I open the
workbook i have a macro that does all the formatting for me, but i have to go
in and manually totall the last four collums of the ...

This is my first attempt at a Dialog Box and I'm a bit stuck.
I've created a User Form which comprises a List box containing a list of
names and a Text Box to which the User adds text then if they press OK I want
the value selected in the List Box to be "looked up" against a list ...

Yesterday I asked a question about enabling chart events, and am grateful for
the replies.  While I was waiting, I figured out, using a chart sheet, how to
use VB to create custom chart tips when I mouse over a point (thanks to Chip
for some of the code).  The problem I ma having ...

I have a worksheet with 2 columns, the first column contains a quantity,
and second contains a "Unit ID" (string).  Any Unit can appear several
times throughout the list.  I am wanting to generate another Summary
List and I figured that a collection would be a good way to go, now I

Can someone explain to me why this fails in Excel 2000?  They're getting
an error: *Microsoft Visual Basic Compile Error: Named Argument Not
Found*
Code:

i have written a little code to add some new items to the "cells" right
click menu.  the only way i could figure out to use a right click menu
was to call a second sub that opens the userform.  here's what i am
doing now: