Selecting the first cell in a selection, then the row of that cell

[gbutton]

So, my sheet is sorted in column H and the following code will select the first row with different information

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.

 

[storm8]

are you familiar with immediate window? (ctrl+g in vba window) you can test all of it there.
type

sheets(2).columns(1).select

or

?sheets(2).columns(1).address

so the above code select entire column of data (columns(1))
the rest is just simple "=COUNTIFS" worksheet function. It checks if the data on currently evaluated row (eg Appliques_Broad_Acanthus) is already in destination. if not, destrw will move one row down and the data will be pasted.

there are many approached selecting ranges on worksheet, my favorite one is using resize. U can google many info how it works, the basics are

range.resize(rowsToResize, colsToResize)

so if you do range("A1").reisize(2,2) you'll get A1:B2
same way you can use negative

and by "select everything to the left and right" I dont know what you want :/