Užitočné (1) | Kabaka123 |
Sub Macro1() ' OK pre súvislú oblast ' Range("A1").Select ' Selection.CurrentRegion.Copy ' PocetRiadkov = Selection.CurrentRegion.Rows.Count ' Pre oblast s prázdnym riadkom PocetRiadkov = Range("A50000").End(xlUp).Row - Range("A1").Row Range("A1", Range("B1").Offset(PocetRiadkov, 0)).Copy Workbooks.Add ActiveSheet.Paste Range("C1") = "1.Cislo" Range("C2:C" & PocetRiadkov + 1).Select ' Selection.FormulaR1C1 = "=VALUE(LEFT(RC[-1],1))" Selection.FormulaR1C1 = "=IFERROR(VALUE(LEFT(RC[-1],1)),"""")" Selection.Copy Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False Application.CutCopyMode = False Range("A1").Select End Sub
Užitočné (1) | Kabaka123 |
Excel - makro pracujuce s dynamicky sa meniacimi datami