L
LennyJo
Can you verify/comment on this? I have found Excel crashes when Advanced
Filter is ran from a sheet other than the data list sheet and any of the
list labels are conditionally formatted. This procedure works fine as long
as a list label is not conditional formatted, even if the data is
conditional formatted. It also works regardless of list labels being
conditional formatted as long as the extraction is made to the data list
sheet. I've replicated this in v2002 and v2000.
Here's a simple test to replicate the crash...
In a new workbook...
Set up a simple data list on Sheet1...
A1: ID
A2: ID1
A3: ID2
B1: Data
B2: 1
B3: <empty>
C1: Name
C2: Tom
C3: Tom
Conditional Format A1...
(whatever)
i.e., Cell Value Is Not Equal to ="" Pattern=gray
Set up a simple criteria area on Sheet2...
A1: Data
A2: 1
B1: Name
B2: Tom
Activate Sheet2 and run Advanced Filter...
Action: Copy to another location.
List Range: Sheet1!$A$1:$C$3
Criteria Range: Sheet2!$A$1:$B$2
Copy to: Sheet2!$A$10
Does it crash?
Thanks,
LennyJo
Filter is ran from a sheet other than the data list sheet and any of the
list labels are conditionally formatted. This procedure works fine as long
as a list label is not conditional formatted, even if the data is
conditional formatted. It also works regardless of list labels being
conditional formatted as long as the extraction is made to the data list
sheet. I've replicated this in v2002 and v2000.
Here's a simple test to replicate the crash...
In a new workbook...
Set up a simple data list on Sheet1...
A1: ID
A2: ID1
A3: ID2
B1: Data
B2: 1
B3: <empty>
C1: Name
C2: Tom
C3: Tom
Conditional Format A1...
(whatever)
i.e., Cell Value Is Not Equal to ="" Pattern=gray
Set up a simple criteria area on Sheet2...
A1: Data
A2: 1
B1: Name
B2: Tom
Activate Sheet2 and run Advanced Filter...
Action: Copy to another location.
List Range: Sheet1!$A$1:$C$3
Criteria Range: Sheet2!$A$1:$B$2
Copy to: Sheet2!$A$10
Does it crash?
Thanks,
LennyJo