Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Code / Add In to remove unnecessary white space
Can anyone supply me with the code or suggest any web-sites that might
provide a suitable Add-In for Excel that I can run which would A - Remove any worksheets from a workbook that has no entries on it B - Delete all superfluous rows and columns The company I work for are being very critical about the size of shared spreadsheets being forwarded over the network so I am looking for a routine to delete all the excess baggage in files to be sent to other users. I have set up Excel to only give me 7 worksheets on a new book but if I only use one worksheet and only use the range A1 to H10 I want to be able to "delete" every other worksheet and unused rows and columns. Thanks Gazza |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Code / Add In to remove unnecessary white space
You can delete the other sheets, but not the rows or columns. Excel has a
fixed number of rows/columns per sheet that cannot be changed. -- Regards Ken....................... Microsoft MVP - Excel Sys Spec - Win XP Pro / XL 97/00/02/03 ------------------------------*------------------------------*---------------- It's easier to beg forgiveness than ask permission :-) ------------------------------*------------------------------*---------------- "Gazza" wrote in message ... Can anyone supply me with the code or suggest any web-sites that might provide a suitable Add-In for Excel that I can run which would A - Remove any worksheets from a workbook that has no entries on it B - Delete all superfluous rows and columns The company I work for are being very critical about the size of shared spreadsheets being forwarded over the network so I am looking for a routine to delete all the excess baggage in files to be sent to other users. I have set up Excel to only give me 7 worksheets on a new book but if I only use one worksheet and only use the range A1 to H10 I want to be able to "delete" every other worksheet and unused rows and columns. Thanks Gazza |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Code / Add In to remove unnecessary white space
well how about code that will check all other sheets for input and delete
blank ones. and then check sheets with data and hide all blank rows and columns Thanks Gazza "Ken Wright" wrote in message ... You can delete the other sheets, but not the rows or columns. Excel has a fixed number of rows/columns per sheet that cannot be changed. -- Regards Ken....................... Microsoft MVP - Excel Sys Spec - Win XP Pro / XL 97/00/02/03 ------------------------------*------------------------------*---------------- It's easier to beg forgiveness than ask permission :-) ------------------------------*------------------------------*---------------- "Gazza" wrote in message ... Can anyone supply me with the code or suggest any web-sites that might provide a suitable Add-In for Excel that I can run which would A - Remove any worksheets from a workbook that has no entries on it B - Delete all superfluous rows and columns The company I work for are being very critical about the size of shared spreadsheets being forwarded over the network so I am looking for a routine to delete all the excess baggage in files to be sent to other users. I have set up Excel to only give me 7 worksheets on a new book but if I only use one worksheet and only use the range A1 to H10 I want to be able to "delete" every other worksheet and unused rows and columns. Thanks Gazza |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Unnecessary Space | Excel Worksheet Functions | |||
Remove white space in print preview | Excel Discussion (Misc queries) | |||
How do I remove unnecessary vertical page break? | Excel Worksheet Functions | |||
How do I remove white space around a chart? | Charts and Charting in Excel | |||
White Space in a Cell | New Users to Excel |