I'm using Excel 2003, and I have 5 columns all on the same sheet. I want each
column to have its own sheet. The page breaks are fine except for in 1 case.
The first page takes up enough rows to go onto page 2. The remaining columns
can all fit on 1 page. So, when you view the ...

Is there a way to export an Excel file saved in xls format to MS Works?  I
have a user that does not have Excel and needs to be able to use this file
which was created in Excel 2003.  Am I correct that the file type for Works
spreadsheets is .wks?

I need a cell to format to 3 decimal points max, but I dont want the .000 if
the number is whole.
For example, I need a cell with 33.8140226 to read as 33.814, but if the
cell is 33, I want it to be 33, not 33.000

For a project at work, I need to add a new sheet that contains information
for a new distributor. The problem is, in the macro I have, when I try to
create a hyperlink, it will hyperlink to the same sheet every time. If I
needed to have the macro hyperlink to a new sheet, how can ...

How does one search and replace blank cells with a "."?

I was wondering if anyone can explain to me why Excel files keep gettign
corrupted. I have a user who seems to be saving Excel files and then they are
getting corrupted.
Is there anything I should be checking for? I have tested a product online

DearAll
in Selected Cell Range I have some colored cell (not all selected raged full
of colored cells). I use different colors in selected range. Now I want to
count how many colored cell in selected range? and what is the total of

I have a worksheet  with prices that I don't want customers to copy from and
make their own pricing.  Is this possible?

I understand that in excel 2007 I can have more than 255 columns(256).  I
can't figure out how to increase my column count.  I can't find any reference
in the help.
Does anyone know how to do this?

Hi, I'm trying to set up a template that contains a formatted pivot table
(e.g. presents sums that are formatted as dates).  It looks fine, but the
problem I'm getting is that the field across the top is "holding on" to
values that no longer exist in the source table.  I tried ...

While trying to run a macro containing the following code-
Range("N1").Formula = CountIf("K" & x, "J" & z - 1, "yes") / CountIf("L" &
x, "L" & z - 1, "yes")
error appears saying sub ar function not defined

I have another question about a SUMPRODUCT I am using.
I am using Windows XP and Excel 2000.
Here is the formula:
=SUMPRODUCT(--(Data!$A$1:$A$10000>=DATE(2007,4,1)),--(Data!$A$1:$A$10000<=DATE(2008,3,31)),--(Data!$D$1:$D$10000="Yes"),--(Data!$B$1:$B$10000="Housing

Our organization uses office 97.
I have one users who gets files from others but can only print preview
them and print them. She cannot edit them. I cannot see any setting
that changes this. Others can open them no problem. When she opens

Good Morning All,
I'm currently using the below VBA provided to someone in an earlier thread
by Rick (great idea by the way).
My question is - would there be a way to have this set up to accommodate

I am trying to write an if statement for a range of cells, so that if any one
of the 6 cells has a certain word in them, my destination cell (where my
formula is written), will give my staff members a certain command.  Is there
a way to do this with an 'if' statement, or does ...