i'm trying to write a vlookup that will advise me when a traveller has
visited an airport in belgium..
e.g. the cell will contain something like LHR/CDG/ODL  or ODL/LGW/SEA
Basically in the example above I want it to show me when the cell contains

Hi All........
I am opening a second Excel file and copying the only sheet therein back to
my original file.  All code works fine, except that it requires me to
hardcode the SheetName of the second file.  I would like to be able to

Hey guys, can anyone help me with a macro I just cannot get worked
out. I have a simple "delete Blank rows" Macro, however the "Blank"
cell is just the result of an "IF" function that returns a "" or blank
cell. However the cell still holds the equation so it is not deleting

I would like to remove a macro from a workbook after it has run.
Any thoughts?

Is there a way to protect (not see or change) the VB code but still allow a
user to add/create macros?
Regards,
Sanj

I have a number of macros that I want to be activated in a series by
attaching them all to one 'button' on the work sheet they relate to.
That works fine to start with but because the workbook will be opened and
then saved with a different name by users, the "Application run ..... ...

It seemed pretty simple, drop a spinner on the worksheet, stick some code
into the spinup and spindown to add or subtract 1 to/from the value in a
certain cell. Just because the value is a date shouldn't make any difference,
after all it's just another number.

I have a worksheet that has a drop down list on it.  Within the drop
down list, there are 52 different center names.  When a center name is
clicked, the corresponding data for that center is displayed.  There
are 6 graphs, and the source data for each graph is located directly

I have a rather large spreadsheet (about 150 columns and 14,000 rows) that
I've written a macro on to use validation and conditional formatting based on
certain rules. The problem is that it's hard to find the cells that get
highlighted by the formatting or circle by the ...

I currently have a spreadsheet that I can use to search a folder using
Application.FileDialog(msoFileDialogFolderPicker) to give me a list of files,
then use formulas to find the files I want.
What I want now (for something else) is to search a Folder (preset based on

Okay so I have a spreadsheet for project scheduling  set up with the month
name  April - March in cells G4 - R4 . In cell C6 I have a start date of
04/01/07 and in cell D6 I have an end date of 07/01/07 for example. What I am
wanting to do is have each cell under each month turn ...

I am automatically creating shapes within cells on a sheet but do not want
them overlaping.  I do not know how many there will be within each cell.
Is the a way to determine if a new shape will overlap an existing one so it
can be shifted down out of the way?

I have two columns in a sheet one with values and one with check box
activex control
value1   checkbox1
value2   checkbox2

As so often happens, my manager has now decided he would like to do it
another way. (Going Back to my BMX example)
Colour Codes    ProdID    Desc    Price
            2374    BMX Bicycle      £99.99

My combobox DISAPPEARS when the event handler is triggered!
If I comment out Me.Pictures(1).Delete, it works fine.
If I step through the code - it works fine!!!
I am sure it isn't hidden b/c when I go and create another one, it is