Užitočné (2) | Kabaka123, white_black |
Užitočné (2) | Kabaka123, white_black |
Sub Makro2() ' ' Makro2 Makro ' Makro zaznamenané 10.3.2016, Marcel ' ' Range("G1").Select Selection.Copy Range("H1").Select ActiveSheet.Paste Range("A2:A7").Select Application.CutCopyMode = False Selection.Copy Range("H2").Select ActiveSheet.Paste Range("B2:B5").Select Application.CutCopyMode = False Selection.Copy Range("H8").Select ActiveSheet.Paste Range("C2:C3").Select Application.CutCopyMode = False Selection.Copy Range("H12").Select ActiveSheet.Paste Range("D2").Select Application.CutCopyMode = False Selection.Copy Range("H14").Select ActiveSheet.Paste End Sub
Užitočné (1) | white_black |
Excel - vzorec na zobrazenie mien zo 4 stlpcov do 1 stlpca