I am having problems matching a range of number in the above cell range

Sorry for the previous post with no info.
I'm comparing data on 2 different sheets in a workbook.  To do this, I
create a  reference field based on fields appearing on both sheets.
Originally the reference fields contained a cost center, month, day, and

I have a very strange problem.  When the following code executes and the
condition is not met, it goes to LoadDataExit as expected, but then instead
of stopping when it gets to the end, it goes back to cmdLoadData and executes
repeatedly.  This happened once before in another ...

I am uploading data, and in column A it post the times like this:
01.31.06
02.00.06
02.31.08

How could I track border drawing. Excel doesn't seem to generate this event.

I have 3 combo boxes that corresponds to day, month and year. When the user
opens my form, those values should be automatically with the current day,
current month and current year, but also open to change it.
I can make the values to be changeable, but i can´t set those current ...

I have a need to drag a cell value from one part of a spreadsheet to another
part of the spreadsheet in such a way that when the values replace the old
values at their new location I do not get a #REF error.
What I'm trying to accomplish is this: I have a list of data that needs ...

I am trying to open an old (very old) Lotus 123 file with excel 2003. The
file extension is .123. Excel gives me a message "Cannot open Lotus 123 file".
Any suggestions? Are there other tools available that will do this?
Thanks

Dear Excel Gurus,
In C, one can mask off certain code segment by using macros like;
#ifndef DISABLE_XXX
//Code to be disabled

I'm using Excel 2003 & AutoCAD
I have an XML file of point co-ordinates that I use to create 2d symbols for AutoCAD.
On the Userform I would like an Image of each of the symbols to display as they're selected from a listbox.
To do one for each would take for ever (& they're likely ...

Worksheet.Unprotect within WorkbookBeforeSave event fails if Save initiated
by VB
-----------------------------------------------------------------------------------
I trap the WorkbookBeforeSave event successfully and reliably.

I'm not a programmer, but often can make things work my own way...
except for now.
At "http://users.telenet.be/coppenskurt/help/sinter.xlsm" you can find
my problemchild (Office2007 with macro). At the opened sheet, I create

I have this code:
ActiveCell.FormulaR1C1 = _
       "=VLOOKUP(RC37,'PRICING TEMPLATE II .xls'!Cat_Code,2,0)"
Used Macro recorder and it works to an extent. I have to manually copy and

In a data containing worksheet, in column "A"
I would like to write a macro which finds the cell with content
"text2delete" and delete all the rows below including this "text2delete" row.
Something like below. Any help will be appreciated greatly. Thanks

Does anyone have a definitive answer to this? I am being asked to be the
"volunteer" for Excel 2007 for my office and as I do a lot of VBA and Excel
development I need to know if this is going to jeopardize my ability to
create and distribute excel 2000 workbooks to the rest of ...