Can I ask a question about the third argumnet in SUMIF, the sum_range.
If I just enter a single cell-ref for the sum_range the formula still works
as though I have defined a full range.  Excel seems to take the cell-ref I
input as the starting point of a range the same size/shape ...

I have created a pivot table in the same workbook as the data source but
whenever I try to refresh the data I get a message saying "This command
requires at least two rows of source data.............."
On checking the data source some cells on only one row are selected.  If I

I am auto-updating a daily productivity sheet for employees, and I
need to know how to do the following:
=IF($B$1<1,"",IF($B$1=1,VLOOKUP($A4,$A$3:$B$68,2,FALSE),????????))
I need to know what I can put in the ???????????????? part for the

I have numerous cells with over 3500 characters in them.  In one case, only
about 2000 characters are displayed.   Is there some way to get all the
characters to display.   Must I format the cells a specific way?
Thanks,

Hi, Excuse my lack of experience with excel, I tried to get an answer
googling for this problem I have, but I didn't succeed yet solving
it.
I'm trying to fill a form using excel, but I want that whenever a cell

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:

Are there any templates for Palm Hand Held Devices?
Derrick

Just had a new security update. I am suing XP Home and office 2003. Now I am
getting an error when I open excel.
Microsoft Visual Basic
Run-time error-2147467259(80004005)

Has anyone ever heard of a marquee in an excel work sheet?
I'm wanting to put one in but cant seem to be able to.
I've been using Office 2003 in the past and just upgraded to 2007 but cant
seem to find any way of doing it.

Running XP, SP2, Excel 2003, SP2.
I use Microsoft's Virtual Desktop Manager (MSVDM).  If I have an Excel
spreadsheet open in one window, switch to another window, then switch
back, all of the default menus and toolbars have disappeared.

I have an excel file template that automated to open from an Access
application that will 1) save the template as a new file with the
current date/time appended to the file name, 2) pull data from an
Access database and format the data into a usable mail merge file, and

Hello to All,
In relation to my previous posting I thought of something else but still
need help:
=IF(Constants!B25<>"",Constants!B25,Hide current row) is the formula in cell

Further to
http://www.microsoft.com/communities/newsgroups/en-us/default.aspx?dg=microsoft.
public.excel&tid=8532b88a-79c6-4a3d-a542-fcb21327dcff&cat=en_US_e064c9ec-14bf-4e
f7-ba07-6a1970559f64&lang=en&cr=US&p=1,
Here is a list of names from all the xls files I'm working with which ...

In my VBA project I have a lot of codes...
But I want that in one code create a variable to use in another code.
For example:
sub code_1()

I've cells on a sheet which are referenced by formulas which are on
different sheets (about 20) on the same workbook, and I'm looking for
a way to get all these formulas. I've tried:
1) The Trace command, but I see only a table icon every time I've this