Is there a way to get the object above a cell using VBA?
Thanks in advance

I have the following code that enters Debug at the line that says
"ActiveSheet.Paste". The target sheet i.e. E-Figures is not protected, can
anyone see any reason for this? It states in the dialogue box "Paste method
of worksheet class failed"

I have two problems:
1)  I need to count a row of 6 (AA4:AF4) -- but if it has zero for a
quantity, I need "Count" not to include these in total.  How do I get around
this?

I was wandering if someone could help me with the following:
I have 3 files which open each other allong the way. For example.
File 1
File 2

I am trying to get the length of the longest cell in a range and use the
array {=len(a1:a1)}. What happens is that it picks up the length of cell A1.
Is there a way in a formula to determine the longest cell length in a range,
or through VBA.

I have a work sheet that is linked to a system that I cannot access.
To bring a value, the formula is the following:
=mxdb|quotes!dvn.last
that brings a result for the value or item "dvn"

When I press tab to move from a cell to the one next to it, instead I am
moved to the first cell to the right of what is showing on the screen.  For
example, if I am in A1, press tab it jumps to P1 if I have a full screen
showing.  I haven't been able to find anyone else this ...

Is there a way to change the behavior of the Tab key so that rather moving
to the next cell to the right of the current one, it instead moves down to
the cell below the current one?  I find that I want to Tab down more often
than Tab right and the left hand is usually better ...

I am using a control box list to drop down the various part numbers that we
use.  I then use that number as part of a VLOOKUP function to return
corresponding data.  This problem is that VLOOKUP sees the number in the
linked cell with "  "  around it.  Why? and how do I get rid of ...

I am trying to round a money value to the nearsest 25 cents and it keeps
rounding to the nearest dollar HELP

It seems if I put a comment in a column header and turn on autofilter for
the rows below, and then protect the sheet, the comment feature won't work.
That is, when I hover over the cell with the comment (and the filter
drop-down icon), the comment won't show - the mouse becomes the ...

I have the following formula that is not producing the correct result for me
=(IF(AND(E16>=4.5,E16<=5.999999999),0.25,IF(AND(E16>=6,E16<=7.999999999999),0.5,IF(AND(E16<4.499999999,E16>0.00001),0,IF(E16>8,0.75,0)))))
It is formatted as [h]:mm
In my instance E16 is greater than 6 but ...

I am underlining numbers in a balance sheet in Excel 2002; the underlines
keep misaligning, like an overstrike instead of an underline. At the to of
the page, all is good - by the bottom of the page the overstrike is prominent.
Carole Drake

I use Excel 2003 in XP
I can't get the macro toolbar to become visible when I am
recording a macro. I have right clicked on the top and
cannot find the toolbar in the list.  I want to use the

How do I designate an entry as the column head/label/name vs. data entry?