Home |
Search |
Today's Posts |
#6
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi Kris
Forgot this PS Also if anyone knows how to strip the formating from the text that has been copied by the script into new worksheets I could use help with that as well Add WSNew.Cells.ClearFormats below WSNew.Columns.AutoFit WSNew.Columns.AutoFit WSNew.Cells.ClearFormats -- Regards Ron de Bruin http://www.rondebruin.nl "Kris" wrote in message oups.com... That worked great thanks. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Column Width using Ron de Bruin script | Excel Discussion (Misc queries) | |||
how do i turn off debugger and script editing | Excel Discussion (Misc queries) | |||
Running a script while editing a cell | Excel Discussion (Misc queries) | |||
Ron de Bruin (ADO help) | Excel Programming | |||
Excel 2000/XP script to Excel97 script | Excel Programming |