Determine Current Selection

[Gary]

Hi All

How do I deretmine what the current selction is in VBA.
ie. if cells e1 to e6 are selected display a message box
with the range.

Thanks

 

[JE McGimpsey]

one way:

Public Sub PostRange()
MsgBox Selection.Address(False, False)
End Sub

 

[Frank Kabel]

Hi
try something like
msgbox selection.address

 

[Bob Phillips]

Msgbox "Selected cells are in the range " & Selection.Address

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)