I need to programatically pull down a web page with a URL that
includes brackets.  Excel *thinks* I want to be prompted to enter
paramenters.  How can I disable the parameters and/or escape the
brackets if they need to be included in the webquery link.

I wish to prompt the user for 2 parameters(M, N) inputs for every 26th row.
This is what i have in my macro but somehow it does not work. Is there any
problem with my coding?
E.g.

I have an excel sheet. i want to calculate the number of rows in the
excel sheet using Vb6.
This is the code that i have:
Dim S As String

have not been able to get text to function as trigger
Useing following have compile problem useing IsText say wrong argument
Have no trouble when useing numeric value.
Target column 12 will all ways have text in it. It is  description cell

I need some some with this macro formula.  In excel, the formula is
displayed as text and I want it to be a number.  There are numbers in the
iRow of M, F and N.
The problem is the scale factor, I think.  I'm tried to change Scale Factor

Hi, I tried DoneEx and now I want to remove it from Excel. I unchecked
it in the Add-Ins menu but the drop down box and toolbar still appear.
There is nothing in Add Remove Programs.
Does someone know how to remove it?

i have a sheet that contains a database of products.  Range("Products").  The
criteria range is above it ("FilterCriteria").  This sheet is not hidden, but
is not active.  i have a userform with a combobox to choose a filter criteria
for the range.  For some reason, when the ...

I use the following function to evaluate the contents of a text box on my
userform.  
i want the code to allow either Numbic OR Null values.  If the value in the
textbox is text, i want the system to fire a message stating the field does

I have one column of 50 rows in which I put input Whole numbers.  In cell A1
I may input 20. When I input that I may want the text color red or I may want
it to be blue.  How can I dictate what color is used with out having to
change the color manually.  I was working along the ...

I have a date/time in the form of:
12/24/2006  4:21:49 AM
I want only 12/24/2006.
How do I get rid of   4:21:49 AM ?

I have two columns of Work Order Numbers, A & C
  A                  B                 C
WO000023                 WO000002
WO000027                 WO000003

This code is in my data worksheet whenever any data is copied to other sheets
the on key apps. go with it. Can I stop the on key apps. from being active on
sheets copied to? Ckeck up is a procedure that checks for row data completed.
I thought that as a private sub it would only ...

When you reference a cells contents in another cell is there anyway to also
bring over such things as the background colors, bold, font, etc?

My main worksheet has a column with a pulldown for valid entries.
Is there a way to remove this valadation when copying the data in this
column to another sheet.
I have the same problem in another column

I have some data which presents active days like this NNYYYYN or any
combination of them. I am told I can store the value of all combinations
in a single integer. I have read that this can be acheived by using
bitwise comparison. Unfortunately, I have never used this so don't