Hi All,
Loving everyones work on here - I have learnt so much!
I was hoping to receive some help for the following:
I have a macro which implements an advanced filter on a range. The next step that i need is to only select the cells which are NOT highlighted in yellow from what the filter has returned. This filtered data (with highlighted rows omitted) needs to then be copied and pasted to a new workbook.
This is my code so far:
Gratefull for any assitance!
Thanks
Loving everyones work on here - I have learnt so much!
I was hoping to receive some help for the following:
I have a macro which implements an advanced filter on a range. The next step that i need is to only select the cells which are NOT highlighted in yellow from what the filter has returned. This filtered data (with highlighted rows omitted) needs to then be copied and pasted to a new workbook.
This is my code so far:
Code:
Sub Select_data()
Application.Calculation = xlCalculationManual
Application.ScreenUpdating = False
ActiveSheet.AutoFilterMode = False
If ActiveSheet.FilterMode = True Then
ActiveSheet.ShowAllData
Range("A1:AU1000000").AdvancedFilter Action:=xlFilterInPlace, _
CriteriaRange:=Sheets(1).Range("B1:B100"), Unique:=False
Application.Calculation = xlCalculationAutomatic
Application.ScreenUpdating = True
End Sub
Gratefull for any assitance!
Thanks