macro_user
Board Regular
- Joined
- Mar 9, 2009
- Messages
- 101
hi...
i have a sheet say sheet1... i copy sheet1 through my macro and rename it to sheet2... in sheet2, i need the column width to be big... i dont know how to say this, but the columns width should be formatted in sheet2 from my macro... suppose i have 1 big line of data, i want the column to be resized according to the data present inside the columns... kindly help me on this...
i have a sheet say sheet1... i copy sheet1 through my macro and rename it to sheet2... in sheet2, i need the column width to be big... i dont know how to say this, but the columns width should be formatted in sheet2 from my macro... suppose i have 1 big line of data, i want the column to be resized according to the data present inside the columns... kindly help me on this...