I have a spreadsheet used as a form that uses name ranges.  I have
found a situation where a user has somehow deleted or removed a name
range.  When I go into the named range, there is a reference error to
the range.  The range is only one cell.  This poses a problem since a

For some reason all my numerical entries are being entered as a decimal.
Example: I enter 65 in a cell and it changes to .065
This happens regardless of whether the spreadsheet is new or existing.
Anybody know of a fix?

I have Office 2003. I had something I wanted to do and am not sure if it is
even possible. If anybody knows how, please tell me. I'd greatly appreciate
any help I can get. What I want to do is to have one column in Excell be for
employee name and one be for the name of the ...

Suppose the user has selected several non-contiguous groups of cells, and
then he pushes a button which calls the VBA routine "Demo_Routine"  What
would the code of "Demo_routine" look like if it were to put,  say, to put
the word "Hello" into every cell in each of the selected ...

I have an Excel spreadsheet that was saved with the .xls extension.  However,
when I open it, instead of the text that was typed into the spreadsheet, it
now shows html language.  Example:
HTML {BACKGROUND-IMAGE: url('Images/spacer3.jpg'); MARGIN: 0px; LINE-HEIGHT:

How do I creat a process where I can have a user select boxes in each row
(radio button or similar) and then export those selected rows to another
sheet of just items they selected?
Thanks!

When using excel.  I want to color code my text.  I cant not see the color
text while in excel. I only see it when I go to print preview.

Assume contest list with varying contestants. Now however they fall
into their places, the ranks will be have 35 places total. There are
more contestants, but we are only concerned with the final 35.
To kind of flip it around:

We are getting ready to move to Excel 2007 from 2003. We have some macros
that are stored in the PERSONEL.xls folder that loads when you start Excel. I
have not been able to find the same functionality in 2007.
in 2003 I had to make a macro and save the file then make the file ...

anybody who knows  what format i need to  present an IP address in binary
format like 11111111.11111111.11111100.00000000 ?
thanks

I saved an excel spreadsheet but when opening it, the data/text is now
showing up in html format.  Example:
HTML{BACKGROUND-IMAGE: url('Images/spacer3.jpg'); MARGIN: 0px; LINE-HEIGHT:
125%; BACKGROUND-REPEAT: repeat-y; FONT-FAMILY: "Gill Sans", "Gill Sans MT",

I have to find, in a large workbook (12 sheets), every instance where
there are more than 255 characters per cell. I really don't want to
have to use the LEN formula because there are so many cells I need to
check. I'd much rather just write a macros. I'm struggling with how to

Bob, I am studying your wonderful article on sumproduct.  I have this:
           A              B
1        Make        Month
2        Ford          June

I have a problem. I am entering a list of items we have in inventory, the
serial numbers are a combination of numbers and letters. a few have numbers
to start and end in E77.
an example is 3934576E28

Hi, I am using the IsError function nested in an If statement to try and get
the macro to skip over some steps if the search comes up empty.  I pass the
search variable (Acct) from a function based on the number of the loop
(counter).  Works fine if the search has a positive ...