Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Mouse click not selecting correct data point | Charts and Charting in Excel | |||
Selecting and applying the correct forumla | Excel Worksheet Functions | |||
Need urgent help selecting correct test!! | Excel Worksheet Functions | |||
Selecting the correct number from a range of cells | Excel Worksheet Functions | |||
Selecting range in list of range names depending on a cell informa | Excel Discussion (Misc queries) |