Address of Freezepane
 

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
--
"There are 10 types of people in this world. Those who understand Binary
and those who don''t ..."

Address of Freezepane
 

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.


"Bony Pony" wrote:

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
--
"There are 10 types of people in this world. Those who understand Binary
and those who don''t ..."

Address of Freezepane
 

Fantastic Mike! Thank you.
--
"There are 10 types of people in this world. Those who understand Binary
and those who don''t ..."


"Mike H" wrote:

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.


"Bony Pony" wrote:

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
--
"There are 10 types of people in this world. Those who understand Binary
and those who don''t ..."