For a Limited Period!
Buy 2 ~ Free 1 pax OR Get 30% off for every pax on our scheduled classesAnalyzing Data with Power BI Microsoft Excel - Power Query (M365, 2021-2010) Microsoft Excel - Power Pivot (M365, 2021-2010) Please This email address is being protected from spambots. You need JavaScript enabled to view it. for more info. |
![]() |
VBA - Current Cell Address* 30/06/2010
To get the current cell address (or current range) to perhaps incorporate into your formula, you could use the following code.
Sub MyAddress()
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
End Sub