I need to have two windows of the same worksheet open, but I need filters on
only one.  I did it yesterday, but somehow can't seem to get it to work again
today.  Any help??

I want to know what does financial excel command "PMT" mean?

I have a master price list that is linked to another worksheet in the same
file.  I have a column for the date that I update the pricing, although some
cells don't have anything filled in.  When I copy from a cell that has
nothing in it and paste the link in another worksheet, it ...

Hi,
Is it possible to use this function below, to then return the value of the
matching cells in Col I. For example if there is a direct match for A2 in Col
E, then in either this cell of another return the value in col I relating to

I realize that this is a repeat of a question from yesterday - but no one
answered it.
The macro below will safe a draft when outlook is open, but will not when
outlook is closed. How can I make the change to save a draft - even if

I have a worksheet where the mouse seemingly is selecting horizontal blocks
of data- the cell I click in to the last row of the entire sheet, not data
Happens in only  2 worksheets (different workbooks) in both 2003 and 2007
versions of the file, but just noticed it after ...

I would like to count the number of digits into a cell, for example:
Cell A1 = 33541  the result I am looking for is 5, because there are 5
numbers inside that cell.
Or the number of letter in a word, for example, cell A2 = "CAR" so the

I have a macro that creates user workbooks from library worksheets that are
copied and renamed as needed to set up the file.  The library worksheets have
a number of named ranges, so when I generate formulas on a summary worksheet
in this workbook to reference a particular cell, ...

Excel 2007 on Vista Business
If I use File/Print/Print Preview or the QAT Print Preview, I can not print
what I am previewing.  I simple get the little "beep" that seems to be
indicating you can't do that from here.

I'm trying to create cells in a worksheet which are text with calculated
dates & numbers imported from other cells in the workbook.  My problem is
that the date reverts to the numeric form & the numbers have many decimal
places.

I have UTF-8 encoded tab delimited data files.  They have the UTF-8 header  
"EF BB BF".  These files would open up perfectly in Excel 2003, but in 2007
the special characters are all garbled.  Is there a setting for Excel 2007 to
recognize UTF-8?

I have the following code and when the data form opens I want it to be on the
first record.  I thought I could enter something like
Range("A3").Select - just before the data form line
but I get an error - Select method of range class failed.

I inserted an image to a spreadsheet, resized it, placed where i wanted and
locked it in place. Everytime I scroll down the sheet or save my work the
image dissappears but, will print out. It seems like its not there unless i
click the area and the grips appear. Please advise.

Good morning, i have a situation where i have a conditional format to do a
traffic light, but i want to use the same data to manipulate arrows in the
adjacent cell, this will point up when red, right when green and left when
Amber.

Under:
File => Properties => Summary
there is an Author field with my name inside.
How do I change this name to default to another?