| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
KBV - How do i progam a recorded to repeat on mulitple sheets?
For ex, if I record a macro that types a heading. Then I want that macro to
repeat typing that heading in 4 sheets, how do I do that? ( I'm new to macros)... Thanks! |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
KBV - How do i progam a recorded to repeat on mulitple sheets?
Sheets(Array("Sheet2", "Sheet4", "Sheet5")).Select
With Range("A1") .FormulaR1C1 = "This is a heading" .Font.Bold = True .Font.Underline = xlUnderlineStyleSingle End With -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "KBV" wrote in message ... For ex, if I record a macro that types a heading. Then I want that macro to repeat typing that heading in 4 sheets, how do I do that? ( I'm new to macros)... Thanks! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Microsoft Visual Basic: Compile error: Sum or Function not defined | Excel Worksheet Functions | |||
| How to repeat a code for selected sheets (or a contiguous range of sheets) in a Workbook? | Excel Worksheet Functions | |||
| Repeat tasks automatically to others sheets | Excel Discussion (Misc queries) | |||
| Header repeat across Sheets? | Excel Discussion (Misc queries) | |||
| How do I convert an Excel workbook that has mulitple sheets into . | Excel Worksheet Functions | |||
Linear Mode
