Freezpanes address - apologies for incorrect post

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
 
M

Mike H

Hi,

You have an answer in your post in general questions
--
Mike

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Address of Freezepane 2
VB Data Validation check - apologies for incorrect post 2
Duplicate value address search - apologies for cross post 0
1004 Cell Protected Error for data validation lists when locked and protected 2
address book manipulation 3
send mail using .oft template 3
David Biddulph is correct 8
Macro: search and transfer text strings from Word to Excel 3

Top