I see quiet a few Excel add-in products from companies like Ozgrid and
Add-Ins.com on the web.
Most promise attractive improvements in functionality and/or
appearance.  And they are all pretty cheap.

When using array formulas with the above functions I got what I didn't
expect, some of them work some of them it seems don't:
1. =ADDRESS({1\2\3},{1\2\3}) works fine when array - entered in a 3-
row/1-col table, displaying as expected :A1, B2, C3

Hi I have a macro where I am trying to copy the entire row of data to a new
sheet if the last two characters of a cell meets one of two conditions.
What I have so far is...
------------------------

Howdy all.
Trying to use range names and SQL to check for new names that may
appear in the RLS BYR Name column of the tbl_imported_data worksheet.
Have another file that works using ADO and SQL but uses the worksheet

How do I eliminate text out of this      2.5 OZ , i just want the 2.5
to show or whatever number is in there regardless of how much digits
it is. I would prefer to have this in the query field and not vba
please. Thank you.

need to format from range E4 to E2003
numbers to be four characters if only three characters
add a zero and a ' for hyperion to recognize any ideas anyone what I had
Range("E4").Select

I have created my own custom form that I need placed on sheet2 once the
submit button (form control) is pressed.  There are 8 fields that I need to
pass.  Any ideas?  Using Excel 07.
Thanks

I use Ron de Bruin's Outlook object model (body) code for sending
Excel related matter via e-mail. All works great but is there a way to
direct the mail from a particular mail A/c that I have on my Outlook
(2003)?

I was using following code as part of macro which worked fine but now it
errors as no blank cells I tried highlighting row 2 and selecting edit goto
special blank cells  states no cells . there are empty cells
Rows("2:2").Select

Aside: Is there a separate NG for XL 2007? --- If not maybe there should be?
In XL 2007, I add a program that adds a custom menu item to the shortcut menu
and it works fine. BUT, two things:
1) A menu item in the ribbon called "Add-Ins" appears. How can I delete or

How can I set the formula for vlookup more than 1 cells?
e.g.
Sheet 1> columns A and B > vlookup to another Sheet 2 columns C
I need to get back the result for columns C

Excel 2003
From file test1.xls I want to run a macro that looks for data in a closed
file (source.xls). The data in source.xls is arranged like this:
ColA   ColB

this is probably really simple and i'm not thinking...
I am currently using a modified version of a progress bar kinbdly made
available on the J-Walk website [link: http://j-walk.com/ss/Excel/tips/tip34.htm]
The steps involved are as follows.

how can I write a macro to do look for a value in a column, say column "C",
if it's greater than or equal to 250,000 then highlight that row (in any
colour), if it's less than or equal to 250,000, then also hightlight that row
(in any color). It will keep on finding value until ...

I have a project... It is not complicated.. but all I want to do is protect
the project. I do not want anyone to be able with ease to view some sheets I
have "very Hidden"
So I have gon to tools, vba project propeties, protection tab. and have