Is it possible for letters to have a value ?
E.G Imagine a blank cell. If i enter the letter M in it, i want the cell
next to it to show the number 8. If i enter the letter A, i want the adjacent
cell to show the number 11 etc etc

I have a database and i have a command button on the form.
on click this opens a report for the specific client on
the screen.  it was working fine, but now doesn't work
after i did a compact and repair.  here is the visual

Is there any other (simple) way to determine the number of dimensions an
array has, other than having to iteratively cycle through calls of
UBOUND(myArray,N) until an error arises ?

I have an excel file that always created a backup copy (.xlk) when it’s save.
This allows the label program to use the backup file without interfere with
the user updating the actual file.  In Excel 97 it works perfect because when
the label program using the backup file and ...

When using the data in a cell as a reference for a vlookup how do I only
consider the first three characters in that cell.
ie,
=VLOOKUP(A1,A1:B10,2,FALSE)

Would like to know how to open an excel spreadsheet and automatically move
to the next new row without data..
Thanks,
Kevin

I'm using a modeless user form to display a "Processing....Please Wait"
message when my VBA code runs.  However, when the form pops up, it's
just a white box.  The label control that I created in the form doesn't
show".

I use a spreadsheet at work (Excel 97) to enter data on a daily basis, in
one of the columns I enter one of about six different notations (i.e.
DST654). I need to do a 10% audit of each of these and need a formula to
highlight each time the tenth one is entered. Can this be done?

I am a new user of excel.  I'd like to set a column so the entry sets a
decimel point for a money entry.  I'd like to enter 12345 and have it show up
as 123.45
I'd really appreciate it if the instructions were step-by-step.

Is it possible to get the following statement to work?  I want to
be able to name a parameter in Visual Basic and then use the parameter
to reference a specific cell in the spreadsheet when the macro is run,
haven't been able to get this to work so far, any suggestions?

Xcel spreadsheets Copied from User's Network Home Folder to Another Network
Folder.
copy  \\network\home\userA\*x.s  \\network\REPGROUP
Getting "object variable or with block.."

I am trying to create an "IF" statement whose value is contingent upon a
range of cells.  Basically, I have 5 cells with 5 different dates.  I also
have a cell which is designated to search the 5 date cells ("IF" statement)
and if one of the cells has a date less than or equal to ...

Dear Madam/Sir
This Word ( BVE ) Is The Abbreviation For ( Brive-La-Gaillarde ) ,It's a
Name Of City In France ,When I Type This Word In Microsoft Excel XP ,It
Appears To ( BE ) ,What Should I Do For Type This Abbreviation ?

I have the following macro running in a workbook.
the problem i have with this is that when it creates the
new workbook with certain sheets missing, it changes the
orignal to the new workbook

I have been connecting to Sybase from Excel (via ODBC) and wanting to
run scripts, but it seems it will only return data from 1 table. Also,
when I modify the SQL it states it executed successfully, but no data
is returned. Any idea what is going on here? Any solutions to my