So, my sheet is sorted in column H and the following code will select the first row with different information
Now, I need to select that row, copy it to a new tab, then find the next column difference. I seem to be having trouble figuring out how to select the row.
I'm pretty new, any help would be appreciated.
Code:
Columns("H:H").Select
Selection.ColumnDifferences(ActiveCell).Select
Now, I need to select that row, copy it to a new tab, then find the next column difference. I seem to be having trouble figuring out how to select the row.
I'm pretty new, any help would be appreciated.