LinkBack URL
About LinkBacks
You were really, really close.
In addition to Paul's suggestion, change this;
to this;
.EntireRow.SpecialCells(12).Copy Destination:=Sheet2.Range("A1")
.Range("A1:N" & .Rows.Count).End(xlUp).SpecialCells(12).Copy Destination:=Sheet2.Range("A1")
You were really, really close.
In addition to Paul's suggestion, change this;
to this;.EntireRow.SpecialCells(12).Copy Destination:=Sheet2.Range("A1")
.Range("A1:N" & .Rows.Count).End(xlUp).SpecialCells(12).Copy Destination:=Sheet2.Range("A1")
Last edited by Jim885; 07-29-2014 at 06:59 PM.
If I helped in any way, please click the star
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks