i'm trying autosend e-mails from excel, but need to every time outoolk opens
already shows subject and message body. The hyperlink function is part of a
formula that provides acees to outlook

I have been working on one of my workbooks, including removing a reference
to an add-in, and in the VBA replacing with qualified calls to its
functions. (See other thread I started.) For some strange reason on one of
the worksheets it has become sluggish when you change a cell's ...

I have tried to run a Public sub code, but it keeps jumping to a private
combo box sub even I did not have a code written for this stop
Would appreciate expertise in the problem

I have a table in Excel, say, which has grade/subject/standards
columns, shown as following:
subject    grade    standards
Math    3    A

I have put custom command bar by name 'GNVR_BRIDGE'  and have put a vb
to make it visible on opening the workbook.
Application.CommandBars("GNVR_BRIDGE").Visible = True.
Very frequently I have to right click and unselect and again select it

I need to create reports in Excel format, and the easiest way for me to do
that is to have an Excel macro pull the data from the database and use the
data to fill in a pre-formatted sheet that it subsequently saves as a new
workbook. So far so good, I got the macro working and ...

This line of code works. But can't I combine the range into one covering
columns 2 to 4?
If Intersect(Union(Range("LOBInput").Columns(2), Range("LOBInput").Columns(3), Range("LOBInput").Columns(3)), Target) IsNothing Then
Don <www.donwiss.com> (e-mail link at home page bottom).

I am calling a macro from Workbook_SheetSelectionChange() where in i am using
something like :
lastCol = ws.Range("A1:IV1").cells.SpecialCells(xlLastCell).Column   which
goes back to my Workbook_SheetSelectionChange() routine again, effecting an

Thanks to this group (Brian Wilson) many years ago, I have some VBA
code which goes through a multi-tab workbook and creates a list of
hyperlinks on the first sheet which go directly to any of the tabs.
There are about 20 tabs, so you can't see them all at once, and the

G'day there One & All,
    Since I can spell XL, I've been nominated as the office guru. I
was asked to modify a spreadsheet (which I wrote, so that's probably the
reason they asked ME). Naturally when I asked I displayed enormous

I need a way to display rows from an access query.  The  rows need to float
in the spreadsheet when queried and the row count changes. Example:  You may
have 3 rows in the first query and then have 6 rows in the next.  The rows
need to expand when this happens not affecting the ...

First, I am using excel 2003.
I have data that is in a "flat" format meaning that data is like:
NAME    MAILING    SHIPPING
name1    address1-a    Address2-b

We have a workbook with a lot of user entered data and we want to set up a
macro to copy it to a new version of a tool (as it's released).    Within the
code, I want to refer to the new version as "aWB".    I want the user to
select the "oWB" that they want to copy their data ...

Excel 2007.  I have posted a couple of times here since installing Office
2007.  I am having code bomb in Excel 2007 that has worked well for years.  
Most people here have little or no experience in Excel 2007 (like me) and
thus cannot help.  How do I get Microsoft to HEAR ...

Can you please advise the easiest method to achieve the following.
I need a formula to perform a calculation using the last cell in a
range that contains a value. The range would be say A1:A365 and each
day the user will add to the bottom of the range (for each day of the