Couple quick questions...

  • Thread starter Thread starter tess457
  • Start date Start date
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!
 
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.
 
You must log in or register to reply here.

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

A couple of quick questions 3
Macro to determine row of page break on modified presentation sheet? 2
Access Dateadd function question.. 0
Printing: page count exceeds pages in tab 1
Trouble with Page Setup to Print 11x17 2
Amazon Login Location Different 4
Filter question? 20
Identifying coloured cells 3

Back
Top