Worksheet3 rowB cells8-15, I need each cell when clicked in to call
Macro PERSONAL.XLS!OpenCalendar (popup calendar)  and select the cell
so that when the date is clicked on the calendar it will be inserted in
the click cell.

I have this code that works
Sub NAMEINLAP1()
Dim t As Integer
   With Worksheets("cardata1").Activate

I have searched posts but can find nothing that covers this. I
originally thought the error brought back may be treated as a value,
and could delete the row based on this value but that doesn't seem to
work.

I am not sure Excel 2003 can do this or not. Here is what I would like
to do.
I have a column (say column A) with some numbers. Some of the cells are
colored green and some are colored red.

I can send a message to a dotNet Textbox and have it trigger the
TextBox_Change event. What I want to do is the reverse. I want to send a
message from dotNet to Excel VBA and have it trigger some event so I can
immediately respond to the event. Since I can't get a Handle for any ...

The line: Set xlSheet = xlBook.Worksheets("Sheet1") fials in my
application since my version of excel is in swedish and uses Blad1,
Blad2, Blad3 etc.
I'm not sure what language my customers use.

how do i know from where mr.x has visited my site?
is there any source availabel throgh vb?

What do you think is the best excel VBA book?
I am looking for one with the most thorough explanations
of functions and has the most practical examples.
Thanks,

figured i'd start a new thread
how do i hide a range of columns using column numbers?
something like:
columns(7,10).hidden = true

Is there any way to alter the code below so that the Selection Value is
restricted to the first 14 characters?
Selection.Value = ListBox1.List(ListBox1.ListIndex, 0)

All,
I've written a function that looks at a range of cells and adds them up
based on the Offset function.  The range of cells will change based on
another defined range's contents.

I need help. I have a website in which i need to write a code which
will allow me to acces the site, fill in the information using specific
blocks in an Excel worksheet.
I have seen many partial codes however, I need understanding more than

So I want to take information that I get via a web query in Excel and
break it up.
The data currently looks like this:
InternalIP:Port ExternalIP:80 OUT masqueraded to FirewalIP:29176

All,
Looking for some assistance here.  I need to take a date, add a number
of CALENDAR days and then ensure that the new date is not a holiday or
weekend.  I cannot use workdays because it adds just workdays and I

When I attempt to copy the conditional formatting of the following, it
does not copy correctly.
     a    b     c
1    First    MI    Last