Quality, Affordable & Flexible
Take advantage of our Microsoft Office Series public courses’ Buy 2 Get 1 FREE package!!
To get the current cell address (or current range) to perhaps incorporate into your formula, you could use the following code.
MsgBox ActiveCell.Address 'absolute cell reference with the pesky $ signs
MsgBox ActiveCell.Address(RowAbsolute:=False, columnAbsolute:=False) 'without the $ signs, you may choose to omit either one Row / Column absolute