Forum home » Delegate support and help forum » Microsoft Excel VBA Training and help » Formatting in reports
|
|
|
The UK's most regular Training information: |
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Formatting in reports
Resolved · Medium Priority · Version 2007
Reply 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
For upcoming training course dates see: Pricing & availability
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.AutoFit
Hope this is useful
Regards
Stephen
Wed 14 Jan 2009: Automatically marked as resolved.
|