copy dynamic range

  1. O

    Copy dynamic Range and pasteSpecial(Transpose)

    Hi all, I need help in structuring a lot of data file and I was wondering If anyone could help me. what I want is to search for cell that starts with "CP" in range (A:A) then copy the next set of row untill the next "CP" and paste(transpose). This is how the data is at the moment: <tbody>...
  2. S

    Copying dynamic range

    By using the following I get the row and column number of the "last" cell with contents:' lastrow = Cells.Find(What:="*", After:=[A1], SearchOrder:=xlByColumns, SearchDirection:=xlPrevious).Row lastcolumn = Cells.Find(What:="*", After:=[A1], SearchOrder:=xlByColumns...

Some videos you may like

This Week's Hot Topics