Hi
how do you duplicate the last column?
and why doesn't this code work?
p.s. I can't change this part![]()
Dim LastColumn As Long LastColumn = Sheets("Tabelle1").Cells.Find("*", SearchOrder:=xlByColumns, SearchDirection:=xlPrevious).Column Range(LastColumn).EntireColumn.Copy Range(LastColumn + 1)
because it's part of another code.![]()
LastColumn = Sheets("Tabelle1").Cells.Find("*", SearchOrder:=xlByColumns, SearchDirection:=xlPrevious).Column
Bookmarks