Works great thanks!

Chad wrote:
try just taking out the workbook reference, i.e.
Application.Run "CBcellformat"

Hope this helps,
-Chad

I recorded the following macro to run three other macros. The code references
a particular workbook name. How do I change that so it will run in any
[quoted text clipped - 18 lines]
Columns("J:J").EntireColumn.AutoFit
End Sub

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...excel/200702/1