Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Filter by error
Hi,
I try to record macro which filter range by error: Sub test() ActiveSheet.UsedRange.AutoFilter Field:=2, Criteria1:="#N/D!" End Sub but I got no data after macro worked. Problem is becouse in Excel 2007 flter by error is very time and click consuming: I have tto unselect "select all" and then select error "#N/D!". In 2003 it was easier: click on arrow of autofilter, press "End" on keyboard and sekect error. Could You halep me with this small macro? Regards, Bartosz |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Error msg on Advanced Filter | Excel Discussion (Misc queries) | |||
auto filter with error value | Excel Discussion (Misc queries) | |||
Advanced Filter Error | Excel Programming | |||
filter error | Excel Programming | |||
Advanced Filter Error | Excel Programming |