1) The below macro generates spreadsheets as and when required and works
OK.
The column width of the spreadsheets is 12.75 which is the default
setting.
How can I set the column width to 0.75 from within the macro?

2) How do you set a variable that will be global, I need it to be
recognised in all macros within the same workbook?

Dim ws As Worksheet
Set ws =
ActiveWorkbook.Sheets.Add(after:=ActiveWorkbook.Sh eets(ActiveWorkbook._
Sheets.Count))
ws.Name = "Spreadsheet Name"


--
grahammal
------------------------------------------------------------------------
grahammal's Profile: http://www.excelforum.com/member.php...o&userid=20336
View this thread: http://www.excelforum.com/showthread...hreadid=568241