Macro Copy assistance

[rlc]

I would like to use this macro on multiple sheets within this workbook with the same ranges. I would like to copy the Hoffman formats to the next new worksheet. I tried removing "Vierthaler", however my syntax or something is not formatted properly. I want to copy multiple times using this macro. Thanks for any assistance you can provide.

' CopyFormatFormula Macro
'
'
Range("F27:F38").Select
Selection.Copy
Sheets("Vierthaler").Select
Range("F27").Select
ActiveSheet.Paste
Sheets("Hoffman").Select
Range("H27:H38").Select
Application.CutCopyMode = False
Selection.Copy
Sheets("Vierthaler").Select
Range("H27").Select
ActiveSheet.Paste
Sheets("Hoffman").Select
Range("I27:I38").Select
Application.CutCopyMode = False
Selection.Copy
Sheets("Vierthaler").Select
Range("I27").Select
ActiveSheet.Paste
End Sub

 

[Jeffrey Smith]

This is a little bit simpler:

Sub CopyFormatFormula()
'
'
Sheets("Hoffman").Range("F27:F38").Copy ActiveSheet.Range("F27")
Sheets("Hoffman").Range("H27:H38").Copy ActiveSheet.Range("H27")
Sheets("Hoffman").Range("I27:I38").Copy ActiveSheet.Range("I27")

End Sub

 

[Jeffrey Smith]

I assumed you always wanted the values copied from "Hoffman" to a new sheet. Run this macro when you have the new sheet activated.

 

[Jeffrey Smith]

rlc,

When you post code, it is really helpful if you use the "CODE" tags. Thank you.

 

[patel45]

Do you want add a new sheet and there copy the Hoffman ranges ? why are you copying in "Vierthaler" Sheet ?

 

[rlc]

Thanks, Jeffrey that did it. I am not sure what you mean by "Code" tags. Code you elaborate so I will properly address the forum if I have a future VBA type question. For Patel45, Hoffman is the source of where I fixed some formating items, and Vierthaler is the person I recorded it to. I have 20 more files to fix. I never really had to manually manipulate a macro before.

 

[Jeffrey Smith]

Below the typing window you will see an "Advanced" button. Click that. Above the typing window are some new icons. One of them looks like the pound sign or hashtag "#". When you click that, it creates a a CODE on and CODE off. You can highlight your code and then click on the CODE icon and it will surround the code with "[ CODE ]" and [ /CODE ]" .