G
grahammal
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.Sheets(ActiveWorkbook._
Sheets.Count))
ws.Name = "Spreadsheet Name"
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.Sheets(ActiveWorkbook._
Sheets.Count))
ws.Name = "Spreadsheet Name"