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;
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
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;
Code:
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