reset last used row and cell

R

Roger Smith

Hi Excel Experts

Is there any way to programmatically set the UsedRange or some other way to
reset the last used row and cell to the real edges of the document so the
horiz and vert sliders work correctly?

Thanks much
 

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

Merging from an Excel file with graphics 1
How to reset Used Range property of worksheet 7
Sr. Citizen Question On Adding A Trendline, Please ? 1
last used row. 4
How to determine Last row of a Page in Excel 7
After I reset my Games they get scambled. Conditional Formatting orMacro messed up somewhere 1
Excel VBA to delete records in Access table and reset the Autonumber 1
Counting records with ADO 30

Top