can someone tell me how to re-write the following code? I believe it would be the equivalent of ctrl + A where you are selecting the entire database. I want a relative reference instead of an absolute because the worksheets will be different sizes.
Please Login or Register to view this content.
Last edited by dalewms2; 09-22-2011 at 03:36 PM.
Hello dalewms2,
I don't understand your question. Do you want to automatically size the worksheet based on the cells that conatin data?
Sincerely,
Leith Ross
Remember To Do the Following....
1. Use code tags. Place [CODE] before the first line of code and [/CODE] after the last line of code.2. Thank those who have helped you by clicking the Starbelow the post.
3. Please mark your post [SOLVED] if it has been answered satisfactorily.
Old Scottish Proverb...
Luathaid gu deanamh maille! (Rushing causes delays!)
Hi dalewms2
Do you mean?
Please Login or Register to view this content.
Hello Barry,
The UsedRange will include cells formatted with borders, colors, and patterns which may extend beyond the cells with data.
I got a Run-time error '438' with the command.
Assuming the data has no gaps, perhaps you want the current region?
Please Login or Register to view this content.
That did it!! thanks so much!!
Thank you too both Colin and Leith
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks