Identify Cell location in VBA
 

James,

Sub test()
Dim rng As Range

Set rng = ActiveCell
Debug.Print rng.Address
End Sub

Rob


"James Stricklen" wrote in message
...
Hello, I'm trying to identify the current cell location using code. For
example, the active cell is A1. I was looking for some code which would
take the active cell and store it in a variable. Any help would be
appreciated.

James