Prev: Excel clicking selects multiple cells instead of a single cell
Next: Excel character limitations
From: Bony Pony on 11 Mar 2010 11:25
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 ..."
From: Mike H on 11 Mar 2010 11:44
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 ..."
From: Bony Pony on 11 Mar 2010 12:59
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 ..."
 | 
Pages: 1
Prev: Excel clicking selects multiple cells instead of a single cell
Next: Excel character limitations