I'm loading data from SQL Server 2000 via a web app written in
vb .net.  I have no problem getting the data in the cells I want,
saving the excel file, and opening it in the browser.  However, when I
try to format the cells, I'm getting this error:

For some reason, I am having a hard time grasping the difference between
listbox and combobox.  I am new to macros in excel.  I am creating an order
entry via excel using userforms.  Here is the background of it:
Worksheet(Order) = Sheet that userforms are utilized to input data ...

I keep getting the dreaded "Runtime Error '91'....
Object Variable or With-block variable not set"
Type RangeTestType
TestCount As Long ' Cell Count

Here is my code, which works fine when the value is assigned, but the
criteria will change each month.  For example the - the code will copy all
for the current month in a new worksheet and then name the worksheet the name
of the filter.  However, I'll run this macro each month ...

Looking to copy a "fixed row" say row 10,000.
Place cursor on row where I want the entry.
Activate Macro, which copies row 10,000, and places it at the current cursor
location.

using 2003
I have a workbook that color codes numeric data based on user
parameters (red, yellow, green)
in an adjacent column I track the trend (up, down, no change -

I need to select the shape in the active row or active cell and delete
that shape before pasting a new shape in the active cell.  Sometimes
the cell will have a shape in  it and will need to be replaced and
other times the cell will be empty and will be just a copy and paste

Worksheet has changeable data clients input in columns W to AP.
Looking for macro to time date stamp in column V in the same row each
time the data is changed anywhere in columns W to AP. Some inputs are
freeform text and numbers, some are from dropdown list.

I'm trying to create a file from an Excel template using either GetObject or
CreateObject. I've had success with these functions but not sure how to apply
it to a template. Currently it opens the template itself instead of creating
a new file. The template will be used by ...

Is it possible run code when a cell is doubleclicked?

In my company i have a shared mailbox which is accesses simultaneously by 2
persons. At the end of the month we are tracking the emails which we received
and emails we replied.
Is any way to copy the details of emails such as sender name, time, and

I created an automation project using MFC and created classes from the Excel
2003 type library. I am trying to get the coordinates of a hyperlink in the
worksheet by using the range get_Top(), get_Left(), get_Width() and
get_Height() methods of the range class. I always get a ...

I am looking for VBA Classroom training.  Can anyone suggest a training
center in the Northern Alabama area to include Nashville, Memphis, Birmingham
or Atlanta?
All suggestion welcome and appreciated.

Hello people,
Id like to construct a macro that copies all rows from the current worksheet
(copy the whole lenght of the row just as leftclicking the 1st row
number and holding and draging down until the last row with data is

For some reason I have a personal.xls and personal2.xls in my xlstart
folder.
It is an exact duplicate - from what I can tell (it is not exactly
same kb's but I have edited personal2.xls before noticing this issue).