I have this situation where I have a drop down list for a number of
suppliers.
There is a summary worksheet followed by a series of worksheets, one for
each supplier all identical in their layout.

Anyone know how to pass the contents of a cell to an sql query? I have a
worksheet that I have connected to an SQL database that I want to query to
get data. The worksheet is like an invoice. What I want is the user to input
a product code and currency then the query to return ...

I've found some spreadsheet joining discussion threads, but I haven't
found one which I think is applicable...
Basically, I have 5 worksheets in an Excel file to be used as a mail
merge.

I am not a spammer but I do have a customer who has given me I a column
with 1200 email addresses in it. The person that entered these emails
sometimes includes or misses one of the following items.
   - an extra space

Thanks to the poster who unlocked the macro mystery - I did a nice
little macro and did twice the work in the last few hours. One problem -
this was to, from a given point, choose the entire row, mouse down one
row and delete the two rows. When I did this by macro, there seemed ...

I am writing a macro where I would like to retrieve the row number and
set an integer variable to that value.
For example I have:
Dim RowVal As Integer

I know how to find cells with **conditional** formatting.  Is there a way to
find cells that have non-conditional formats?  Let me try to be a bit
specific.  How can I find cells that I have applied custom formats
(format>cells>number>custom)?

Googling this doesn't seem to get me anywhere.  I'm finding the same problem on
several ordinary line graphs.  The numbers shown on the X-axis scale (these are
always simple 4-digit years) become more frequently truncated -- losing their
rightmost digit -- toward the right side ...

I have designed a userform which produces a combobox(1) - list of items
from which an item can be selected. Based on this selection another
combobox(2) is produced and displayed on the userform with an item list
from which another item can be selected.

Does anyone know how to send movie files from picasa through Hello! It
transfer them into jpg. and cannot be viewed

I have a spreadsheet that I have set up as a template
(ProductionTemplate.xlt). How do I promt the user to save it under a new
name each time it is opened (to avoid overwriting the template)....just had
a thought, would making it Read Only do that.......

Hi all, my name is Sebastiaan of Holland and i could sure use your help!!!
Thanks for taking some of your time to give me some advice, very
apreciated!!!!
To summarize my problem: I want to export a huge database, and then start a

I would like to try and find a macro code that does the following:
1. Delete rows when cells in column C3:C2000 are less than (<) 50, and;
2. Delete rows when cells in column F3:F2000 are exactly equal to (=)
"0"

No luck so far
-----
Think I just tried that??
And still 00:00

where can I get some resource about creating macros? I was a top expert
in Lotus 1-2-3, and loved writing little macros to make work go faster
and smoother, but MicroSoft doesn't seem to understands macros the same
way and I am depressed about it.