I've found a module that will let me query SQL Server databases via
ODBC. Below I've created a module which does exactly what I want it to
do using concatenated cells in a worksheet. My issue however, is that
now that I've gotten the code correct, excel tells me it doesn't have

Excel 2003
By whatever method, I get to a cell on a worksheet.
Now I want to find out if this cell has a name, or is contained in other
named ranges on the worksheet.

In worksheet A,I have a range of data beginnning in a2;
        A                 B              C                D
1      Unit#    Client Name    Phone#     Address
2      119        Fred Wilson   6561578     34 anystreet

i have 2 sheets in my excel workbook. in my second workbook i have the values
as follows
A   B
ss 10

I have a table in excell with part numbers like 23A12, 837B2, 12E32...
When I want to save this documents as .csv type of file, excell
converts codes that contains E in scientific format of numbers. So
part number 12E32 converts to 1,20E+33! Can someone please help me

I have a macro that splits one sheet with many pages into individual files by
page numbers using the horizontal page break. It works perfectly. However, I
need it to either A - include the header (and margins) from the original file
when saving to the new file or B - use a ...

Hi,
I want to download market data into Excel every 10 minutes from 6PM Sun to
5PM Fri. I have a macro (GetQuotes) to do the actual download, which works
fine. But I have no clue how to VBA running that macro on a schedule,

I am having trouble writing a formula trying to find the Maximum of
two numbers in a row based upon a value in the same row.  Essentially,
I have 3 columns.  Column A has values between 1-5. Column B has
values between 0 and lets say 50.  Column C also has values between 0

this solution deletes the row, I only want to clear the duplicate in
Column A.
Dim rng As Range
Dim i As Integer

My formula that should populate column K is: =SUM(J1/MACRO!G11), which
takes the value in the same row (column J) and divides into a
refereced cell, which will stay the same always.  The macro should
evaluate until the end of the column.

I'm getting an "Application-defined or object-defined error" on the
line below that I've identified...can anyone help me out on this?
Dim last7 As Long
   last7 = Worksheets("Working Sheet").Cells(Rows.Count,

the formula is basically:
=SUM(J1/MACRO!G11)
J1, must change as formula moves down each row, "MACRO!G11" stays the
same

[possibly the wrong group, apologies]
Both in 2000 and 2003, (don't have 2k7, boo) the maximum # of UDFs
that the function wizard is capable of displaying seems to be 8178.
If you have more UDFs defined, they don't get displayed, despite

I am having some trouble with Select Case.  I have a bunch of ifelse
statements that would be run faster as a select case, but i cant get
the syntax.  I want something like:
Function range(incw) as string

I have a problem with the command button, txt and combo box and Option
buttons. They keep shrinking and growing i keep adjusting them
accordingly- everytime when they change size. Is there a way to make
sure these buttons stay the same size? This has become a pain in the