Couple quick questions...

T

tess457

I have a couple quick questions??
1) Is there any way of finding how many rows between the last row o
data, and the page break on the last page.
2) Is there a way to set my userform so it is resizable by the user.
looked under the properties of the form, but cannot seem to find it.

Any help would be greatly appreciated!
 
M

Myrna Larson

RE your first question, check out the HPageBreaks collection. But the last
time I tried to work with it, it was buggy. If you haven't actually scrolled
down to the bottom of the worksheet, trying to get the location of the last
page break caused a crash.

I can't find any way to set a form to "resizable", either.
 
Top