Fri 12 Dec 2008, 16:03Delegate Dave said...
Dave has attended:
Excel Advanced course
Excel VBA Intro Intermediate course
Formatting in reports
I will need to be able to create formatted reports with typical tables on a number of worksheets
Is there a way to create a template object, or series, that I can call rather than cutting and pasting into the worksheet ranges separately
Wed 7 Jan 2009, 14:29Trainer Stephen said...
RE: formatting in reports
Hi Dave
Thank you for your question
It is possible to write a procedure that would;
1. Create a new workbook
2. Place entries and value directly into certain cells
3. Format various cells as required.
as an example, the following code snippet shows you how to create a workbook ad some values and do some basic formatting
Application.Workbooks.Add
ActiveWorkbook.Sheets(1).Range("A1").Value = "My New Template"
ActiveWorkbook.Sheets(1).Range("A1").Interior.Color = vbRed
ActiveWindow.DisplayGridlines = False
ActiveWorkbook.Sheets(1).Columns("A").EntireColumn.AutoFitHope this is useful
Regards
Stephen
