Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Format sheet programmaticlly??
Is it possible and how do you format a sheet programmaticlly in VBA. I would
like to format a newly created sheet once the data is copied or when the data is copied from another sheet. I would like to format the new sheets with borders and header rows with bold names to match the coorisponding data in that column. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Format sheet programmaticlly??
Hi
Record a macro where you format the sheet as desired, then incorporate the recorded code in your own code. Regards, Per On 29 Dec., 00:39, Mekinnik wrote: Is it possible and how do you format a sheet programmaticlly in VBA. I would like to format a newly created sheet once the data is copied or when the data is copied from another sheet. I would like to format the new sheets with borders and header rows with bold names to match the coorisponding data in that column. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Format sheet programmaticlly??
On Dec 28, 6:39 pm, Mekinnik
wrote: Is it possible and how do you format a sheet programmaticlly in VBA. I would like to format a newly created sheet once the data is copied or when the data is copied from another sheet. I would like to format the new sheets with borders and header rows with bold names to match the coorisponding data in that column. The easiest way to generate formatting code is to create a template of what the populated sheet would look like and then format it as desired with the macro recorder turned on. Then go back and make any customized adjustments to the macro that are required and you're done. A real key for making your life easier is to use named ranges and format on the range names rather than specific cell addresses. That way, if the range dimensions change, you don't have to go back into the code and change the range designations. There are other methods for dynamic range selection, but this is a good way to start. Try those first and see how you make out. Good Luck. SteveM |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to format sheet to show first box whilst tabbing across sheet | Excel Discussion (Misc queries) | |||
Can't Format Cells...CAN format whole sheet | Excel Discussion (Misc queries) | |||
VB code to copy sheet format to another sheet | Excel Discussion (Misc queries) | |||
how can I format sheet 1 if the value is found in sheet 2? | New Users to Excel | |||
How do I copy a print format from sheet to sheet in excel ? | Excel Discussion (Misc queries) |