hi
something like
activecell.end(xlup).select


"hawki" wrote:

I am preparing a formula which needs the address of the first cell located
above the active cell that contains information . The key strokes would
normally be "=" then "ctrl + {up}" then "{enter}". What macro language would
achieve this result.

--
l-hawk