The worksheet that you want the active cell address has to be active. So
activate the sheet first then you can get your active cell. For example,

Sheets("Sheet1").Activate
MsgBox ActiveCell.Address

or you can loop thru all the sheets in your workbook and find all the active
cells.

Sub FindSelectedCell()

Dim wks As Worksheet

For Each wks In Worksheets
.Activate
MsgBox ActiveCell.Address
Next wks

End Sub
--
Cheers,
Ryan


"joel" wrote:


I can't seem to get the address of the selected cell that is not on the
activesheet. Anybody know how to do this in 2003?


--
joel
------------------------------------------------------------------------
joel's Profile: 229
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=163314

Microsoft Office Help

.