Text to column, fix width
My chart is dynamic but one problem is that after I refresh data I have to
fix width everytime. ( Data/text to column/fix width/ finish). How can I avoid to do this? Or How can I write a macro so I will automatically fix width Or How can I change this to defaul so I don't have to fix with every time hitting refresh data. Thanks for your help Daniel |
Text to column, fix width
A macro to do this would be easy. Simply turn on macro recording, execute the
tasks you need (Text to Columns, Column Width, etc.), stop recording and save the macro. You can then run the macro anytime you want. -- Regards, Fred "Daniel" wrote in message ... My chart is dynamic but one problem is that after I refresh data I have to fix width everytime. ( Data/text to column/fix width/ finish). How can I avoid to do this? Or How can I write a macro so I will automatically fix width Or How can I change this to defaul so I don't have to fix with every time hitting refresh data. Thanks for your help Daniel |
Text to column, fix width
THanks Fred
I will record a macro and run but How can I make it run automatically when I refresh data? Thanks again Daniel A macro to do this would be easy. Simply turn on macro recording, execute the tasks you need (Text to Columns, Column Width, etc.), stop recording and save the macro. You can then run the macro anytime you want. -- Regards, Fred "Daniel" wrote in message ... My chart is dynamic but one problem is that after I refresh data I have to fix width everytime. ( Data/text to column/fix width/ finish). How can I avoid to do this? Or How can I write a macro so I will automatically fix width Or How can I change this to defaul so I don't have to fix with every time hitting refresh data. Thanks for your help Daniel |
All times are GMT +1. The time now is 09:51 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com