My code works when stepped through where the sheet CSV is opened but
does not work in a button when the sheet is not open.  The goal of the
code is to format then create a copy of the sheet in a separate
workbook.  Please advise of more efficient code than below:

I am trying to create Combo Box on one worksheet to access list of names on
another worksheet and copy name and address into the first worksheet. I have
the Cell link cell on the sheet with the names. I am trying to create the
macro and use the cell link in it to access the ...

Sorry, but I can't find my old post on a similar problem, but I know that
someone here has the answer, since it gets asked occasionally:
I have a worksheet that ends in column CD and I want to insert some columns
just to the left of CD but it won't let me insert even one, says it ...

    D-DAY                   TODAY
    04/01/2008    05/14/2007
322 days    9 hrs    23.0 min    24 sec
0\days    [h]\hrs    m.0\min    ss\sec

Can anyone help with the following:
I want to move some text data from one worksheet to another. Some of the
text entries are partially formatted (i.e., the font of only some characters
in the cell is bold, or in color, etc).

Can I join a cell in one worksheet with another cell in another worksheet
within the same workbook?
Sheet 1 has A2 (Employee Id) with hourly rate in B2
Sheet 2 has A2 (Employee Id), B2 (Hours) and I'm trying to calculate Pay in

I am creating a function that alters formulas in a user selected range.  In
order to avoid looping through each cell in the range I was using the
SpecialCells method but this will not work if the sheet is protected.  Is
there another way to return the formula-containing cells ...

I have several sheets using Worksheet_Change.  They work great. But... if
there is an error the macros stop working. I close and open the workbook and
the macros as still not working. How do I 'start them up' again?
Thanks for any help.

I have some fairly complicated macros set up.  They work fine on my computer,
I have had no difficulty and use them with great success.  However when put
in place on a co-workers computer they do not.  I've already went through
line by line to make sure everything is identical, ...

I have a macro that when the user delete the content of any value between the
range of B10:B500 do the following things.
1.Message box asking if they are sure to delete.
2.If yes is selected,

I have a procedure that loops through a list of hyperlinks on one worksheet
(wsSource) and calls an ImportWebData routine.  The ImportWebData procedure
uses QueryTable.Add to grab the data, place it in a 2nd worksheet (wsTarget)
and name the range holding the import data as ...

I have a spreadsheet that calculates commissions.  Commissions for some types
of items are based on a tiered structure.  Commissions are not paid until our
company has been paid by our carriers.  The spreadsheet I am working with
determines the type of transaction (accessory sale ...

Hi all! I desparately need help with an Excel problem. Here's an
example of what I'm trying to achive below:
In Cell B2 I have a drop down list which contains names of our
brokers.

The macro below returns a forumula that has an address that is absolute.  How
would I force the macro to return an address that is relative (without the
dollar signs)?
ActiveCell.Formula = "=" & ActiveCell.Offset(0, -1).Address & "-4"

I am using Excel 2003. I have a spreadsheet called planning. In one tab,
labelled "plandata", I have my planning data. In a separate tab, I have
created a User Form. This form uses selected fields from "plandata", or it
will. I want to hide the plandata sheet and display the ...