Selecting the correct range
I used A:IV to completly clear all cells (Just in case anyone typed into
them) before coping into it. Would that make all the difference?
"Joel" wrote:
This line is wrong
Worksheets("SS A").Range("A:IV").ClearContents
should be
Worksheets("SS A").Range("A:AN").ClearContents
"Trever B" wrote:
Hi,
Thanks in advance
In the following code it is supposed to select Colums A to AN and copy them
to another worksheet (SS A). The problem is it only does A to V. (Could
have something to do with blank rows/Columns?)
How do I change the Current region to include A to AN
Application.EnableEvents = False
Worksheets("SS A").Range("A:IV").ClearContents
'With Worksheets("Panel Details").Range("A1").CurrentRegion
.AutoFilter Field:=1, Criteria1:="A"
.SpecialCells(xlCellTypeVisible).Copy _
Worksheets("SS A").Cells(1, 1)
.AutoFilter
End With
Application.EnableEvents = True
|