Forum Discussion

ayssmetin's avatar
ayssmetin
Copper Contributor
Jul 05, 2018

couldn't create loop

Im newbie to Excel Macro. I created these codes with macro recorder. but i need to create loop for this operation ranges C to Z. can you help me about this situation

Range("C2:C14").Select
Selection.Copy
Sheets("metod").Select
Range("B6:B18").Select
ActiveSheet.Paste
Range("C18").Select
Application.CutCopyMode = False
Selection.Copy
Sheets(" son 1 ").Select
Range("C15").Select
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False
Range("D2:D14").Select
Application.CutCopyMode = False
Selection.Copy
Sheets("metod").Select
Range("B6:B18").Select
ActiveSheet.Paste
Range("C18").Select
Application.CutCopyMode = False
Selection.Copy
Sheets("son 1").Select
Range("D15").Select
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False

Macros & VBA
tips and tricks

1 Reply

  • Russell Proctor's avatar
    Russell Proctor
    Brass Contributor
    Jul 05, 2018

    Hi,

    It is extremely difficult to work out what you are trying to do by looking at the code.

    Could you describe it in words ?

     

    Russell

Resources