Address of Freezepane

  • Thread starter Thread starter Bony Pony
  • Start date Start date
B

Bony Pony

Hi all,
In VBA, is it possible to determine the address at which a sheet is locked?

I found a property activewindow.splithorizontal and splitvertical but they
give me double length integers. Anyone know how toconvert this int an
address?

Kind regards,
Bony
 
Hi,

Like this

MsgBox Cells(ActiveWindow.SplitRow + 1, ActiveWindow.SplitColumn + 1).Address
--
Mike

When competing hypotheses are otherwise equal, adopt the hypothesis that
introduces the fewest assumptions while still sufficiently answering the
question.
 
Back
Top