address location

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
I think I would play it safe in case two or three cells immediately above
contains data:

If ActiveCell. Offset(-1, 0) <> "" Then
ActiveCell.Offset(-1, 0).Activate
Else
ActiveCell.End(xlUp).Activate
End If
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Combine 2 columns in a dynamic range into one 7
Excel macro 1
Code for multiple select of cells 16
VBA - entering a formula in excel 2
Inserting a Static Date and Time thru a Macro 3
VBA set thick borders around non empty cells in range 0
Grey Fill for all cells that contain a certain string in hyperlinkaddress 4
Find and match text and return column and row reference 0

Back
Top