VBA - Filter to show blanks

[Foz1980]

Hi all,

Please bear with me as my VBA skills are fairly limited (compared to you lot).

I have some code and that I want to do is a filter to show data where column T is blank.

I've tried;

ActiveSheet.Range("$A$1:$T$28").AutoFilter Field:=14, Criteria1:="="

And this does appear to work, but I dont know if this is the most robust way.

Does anyone have a better suggestion or will this always work fine regardless?

Cheers

Chris

 

[Fluff]

That is not filtering on col T it's filtering on col N
I your data is likely to go beyond row 28 try

ActiveSheet.UsedRange.AutoFilter Field:=20, Criteria1:="="

 

[RoryA]

That is the way to filter for blanks in the 14th column of the range, yes.

 

[Foz1980]

That is not filtering on col T it's filtering on col N
I your data is likely to go beyond row 28 try

ActiveSheet.UsedRange.AutoFilter Field:=20, Criteria1:="="

Yes sorry, I did actually mean N not T. But your code has worked perfectly (but using field:=14).

Thank-you.

 

[Foz1980]

That is the way to filter for blanks in the 14th column of the range, yes.

Fluff was right I think, my version would only go to Row 28.

 

[Fluff]

Glad we could help & thanks for the feedback