Problem with VBA Code error

[sats43]

Hi,

Below is the code which i am using it to advance filter with data validation criteria with necessary naming range, its looks good but i am getting the error like "Error 1004 Method 'Range' of object '_Worksheet' failed", can you please look at what the issue is


If Not rngCrit Is Nothing Then
Sheet2.Range("Data").AdvancedFilter _
Action:=xlFilterCopy, _
CriteriaRange:=rngCrit, _
CopyToRange:=Range("ExtractData"), Unique:=False
End If

[JeanRage]

Make sure to use Code Tags ...

[sats43]

I am pretty new to this forum, hence all these confusions, will take care the actions points from next thread

[romperstomper]

You'll need to go back and edit your original post to add code tags before we can answer you...