It could indeed have to do with blank columns. Go to A1 and press
Ctrl+Shift+*. This would select your CurrentRegion (=area completely
surrounded by blank cells). If this selection does not extend to column AN,
then you probably have a blank column before column AN. Deleting the blank
column(s) should solve your problem.

Cheers,

Joerg


"Trever B" wrote in message
...
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