Uzamčeno - nelze přidávat nové příspěvky.
Např.
Sub subCopy()
Dim rCell As Range, rArea As Range
Dim I As Integer
I = 0
For Each rArea In Selection.Areas
For Each rCell In rArea.Cells
I = I + 1
ActiveSheet.Cells(I, 1).Value = rCell.Value
rCell.Clear
Next rCell
Next rArea
Set rCell = Nothing
Set rArea = Nothing
End Subcitovat
Sub subCopy()
Dim rCell As Range, rArea As Range
Dim I As Integer
I = 0
For Each rArea In Selection.Areas
For Each rCell In rArea.Cells
I = I + 1
ActiveSheet.Cells(I, 1).Value = rCell.Value
rCell.Clear
Next rCell
Next rArea
Set rCell = Nothing
Set rArea = Nothing
End Subcitovat
RSS nejnovější články