Prev: Column Coding
Next: Avoiding #N/A result
From: Bartosz on 27 Apr 2010 06:11
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
From: Jacob Skaria on 27 Apr 2010 06:39
Do you mean to filter the second field with #na error? as below

ActiveSheet.UsedRange.AutoFilter Field:=2, Criteria1:="#N/A"

--
Jacob (MVP - Excel)


"Bartosz" wrote:

> 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
From: Bartosz on 27 Apr 2010 06:53
I filter with #N/D!"error. I got it from VLOOKUP function. I need to find
witch data not exist in second table.

Bartosz
„Jacob Skaria” pisze:

> Do you mean to filter the second field with #na error? as below
>
> ActiveSheet.UsedRange.AutoFilter Field:=2, Criteria1:="#N/A"
>
> --
> Jacob (MVP - Excel)
>
>
> "Bartosz" wrote:
>
> > 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
From: Bartosz on 28 Apr 2010 08:20
Hi,
Is here is any chanse to make this? I try with "CVErr" but there is no #N/D!
error.

Regrads,
Bartosz
"Bartosz" wrote:

> 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
 | 
Pages: 1
Prev: Column Coding
Next: Avoiding #N/A result