I wrote a macro that makes a cell equal to a vlookup formula. So m
code looks something like this:
Range("A2") = "=vlookup(A1,A3:B50,3,False)"
Then  I want the custom format of 000000.00 applied to cell A2.

I am looking for help on how to reference a specific worksheet cell to be
used in a SQL (Sybase 11) query.
I have working VBA code that will pull data as long as I hard code the date
or date range; however, I would like a single cell, or even a msgbox to be

i have a little problem with excel: i open an excel file and after making a
few changes i try to save it but i can't because they program tell me:
"impossible to save, a temporal copy have been created "
Any idea about this little head-breaker?

I NEED HELP...
if cell   a1   lets say is     7:00    and I would like to
add 15 minutes to this time in cell   a2   what would be the formula.
Everything I seem to try fails.

I have a protected excel file that I make available to several
computers from our server, just to read. But I need even more
protection: I want patrons to have access to read this file but NOT
to be able to then click the "new" icon to go on and create any new

Help, this is really bugging me:
Periodically my (patched up) Excel 2003 suddenly refuses to evaluate my
(VLOOKUP) formulas, and will only display the text of the formula in the
cell.  Additionally, the cell reference in the VLOOKUP formula will not

I have had this kind of problem before and just don't understand the
problem.  I have a couple of input cells that are date formatted.  Then, I
have a bunch of hlookup functions that find that date in a row of dates and
read down N rows to find a value.  I am getting N/A's right now ...

Is it possible to have multiple named references within a range ID, for example:
Worksheets("Sheet1").Range("Year_1", "Year_3").Value = 0
where both Year_1 and Year_3 are named ranges themselves?
Cliff

Is there a csv (or txt) Save As format in Excel that exports all non-numeric fields in quotes (not just the ones with spaces and/or commas) like MS Access does.  I can't seem to find one.

I AM TRYING TO ENTER A NUMBER THAT BEGINS WITH ZERO'S AFTER I ENTER IT THE ZERO'S DISAPPEAR, HOW DO I KEEP THEM IN

I don't use Excel very often but I need to do something real quick.
I have an old copy of Excel on my computer, maybe Excel 97.
I need to be able to rearrange the order of the columns.
I can't seem to just select the column and drag it to a new location.

I'm trying to create a bar chart which represents %completion of
project.  I need to also include a vertical line on top of this ba
chart which indicates the target %completion.  Is there a way to add
verticle line on top of a bar graph?

I want to replace the zeros in a column.  However I only want the zer
replaced if it is a stand alone zero ie, "0".  If it is "40" I want i
left alone.  How do you do this with the Replace dialogue under Edi
Replace?  I get the impression that there must be a whole set of synta

Is there a way to export or create mailing labels from an Excel spreadsheet?
I am trying to take about 400 names and address from the spreadsheet and
create mailing labels for a newsletter.
Thanks!

I know that normally sheet backgrounds will not be printed when th
sheet is printed.  Has anyone found a way to print backgrounds with th
sheet.
--