Why does my vba filter select the entire sheet if only row 2 has data in it?

[tonywatsonhelp]

Hi Everyone,
So totally confused please help if you can,

I have this bit of code i offten use to filter copy paste,

not had a problem before but for some reason when only row 2 has data in it it selects the entire sheet?
anyone know why?

i've show the code below

please any help would be great

Sub test4()


LrTarg = ODraw.Cells(Rows.Count, "M").End(xlUp).Row
If LrTarg > 1 Then
ODraw.Range("M2:M" & LrTarg).SpecialCells(xlCellTypeVisible).Select



End If

 

[Fluff]

If SpecialCells is anchored to a single cell it will look at the entire sheet.
Try

If LrTarg > 2 Then

 

[tonywatsonhelp]

Oh, wow, thats news !
ok so i will try that work around
Thannsk
Tony

 

[Fluff]

You're welcome & thanks for the feedback.