Hi I got an problem....
I wanna compare cell a1 with b2:e2 (if any of those cells are equal) then
find minimun value in cell b4:e4
of do I do that.......?

This finds the last row in the column with anything in it
r=cells(rows.Count,"a").End(xlUp).Row
But, if that cell has a formula in it that returns "", then the statement
returns that row because there is a formula in it.  I know I could follow

My friend just sent me a document using her 2007 excel software.  I attempted
to open it up and was unable to due to my version being 2003.  Is there any
way that I may convert the file?  Thank you.

Version: Excel 2000 & 2003
* using only one instance
I'm stuck and have no other ideas, I've search the newsgroup and
researched my macros and I can't find my problem with the following

I want to make a some kind of CTRL-F field in my sheet.
If the text (or a part of the text) in cell F1 is found in row A then
select the cell with the text where it was found.
And when I'm in the cell F1, I prefer just to press 'enter' instead of

I can't figure out why I'm getting an "invalid qualifier" error message on
this; each time it points to the word 'Selected' in the code.  Any help would
be appreciated.  (All I want the code to do is:  If an item is selected in
Option2ListBox, then I want to delete any row in the ...

Using Office 2003 and Windows XP;
Is it possible to code a workbook to alter or change its sheet, workbook,
and module protection passwords on the fly? I would like to tie the change
trigger to the workbook's Open event.

Ok. I give in. Tried for hours, and have search the forum and google.
Is it possible to populate a dataform with the combobox1 value. I can pick
up the value, but can't get it in to the dataform.
The code uses the form from the dropdown Data\Form. The form works thanks to

I have a 2-dimensional array [vtData(0, 0)] that is Dimensioned (Dim
vtData As Variant); its Lbound for each dimension is 0 and its UBound
for dimension1 is 4 and its UBound for dimension2 is 2; therefore, 15
elements. (This array is imported into my VBA Code from Bloomberg.)

I have a modal userform in Excel 2003 with a number of textboxes on it.
Sometimes entering data and pressing TAB moves me to the next textbox and
sometimes it just inserts a tab into the current textbox and I have to click
the mouse in the next textbox to get there.

I have done a large spreadsheet with 3 levels.
When I chose one level the spreadsheet (on the litle square top left)
the spreadsheet works very slow, proberly because it recalculate all
the time.

I have created several external named range, for e.g.
='C:\Documents and Settings\madiya\Desktop\[RUIM Master
File.xls]Reciept Data'!$E$1:$E$20000
I intend to use it in sumproduct formulas but on testing I got error

I have a spreadsheet with multiple worksheets.  On the Master spreadsheet I
have a column with a validation list giving users a "YES" or "NO" option.  If
they select the "YES" option then it copies the data in the target,row cells
49,50,51 and pastes it into another worksheet.  ...

I have to start learning VBA. At work I'll be using Office XP, so I'd
like to know if VBA for Excel 2003 is the same as VBA for Excel XP.
I'm asking this because I already have a book for VBA 2003 but not for
VBA XP.

i am quite new to vba programming and i need help with a makro. i want to
compare two columns and write "true" or "false" or something similar in
another column, if the values are similar. the similarity is limited to
lower/upper case letters.