Copy does not get last visible row

[James Snyder]

I am losing the last row of data when using '.SpecialCells(xlCellTypeVisible).Copy'. Since this is not a range I set, I am wondering if others have found this and have a workaround. Below are links to screenshots showing the problem:
Losing NULLs 1 - Bermex's library
Losing NULLs 2 - Bermex's library
Losing NULLs 3 - Bermex's library

            With ftpWkSht
                ' If we have a valid workbook and a valid worksheet, find the bottom row
                ftpMax = .UsedRange.Rows.Count
                Set ftpRange = .Range(.Cells(1, 1), .Cells(ftpMax, ftpMaxCol).End(xlUp))

                With ftpRange
                    .AutoFilter
                    .AutoFilter field:=meterRdCol, Criteria1:=vbNullString ' or "="

                    ' Make a new sheet and copy filtered data to it to be able to address each row
                    .SpecialCells(xlCellTypeVisible).Copy
                    Set filtSheet = Sheets.Add(After:=Sheets(1))
                    filtSheet.name = fltShtName
                    filtSheet.Paste
                    Application.CutCopyMode = False         ' Clear clipboard of copied data

Since the .AutoFilter catches everything as it should, it seems to be a failure of the .SpecialCells function or the labeling of the last row as 'visible'. Any help?

 

[James Snyder]

Thanks for trying. The VBA is tightly tied to a process and that is why I said "I wish I could". Without the environment, looking at the code is all you can do. I am clueless as to why I am losing the bottom row...

 

[RoryA]

Why are you using .Cells(ftpMax, ftpMaxCol).End(xlUp) rather than just .Cells(ftpMax, ftpMaxCol)?

It looks like your last column has some empty rows (as in the row that doesn't get copied), so the End(xlUp) part will restrict your range to the rows above that (the autofilter ignores that and filters the whole region whether you like it or not!).

 

[James Snyder]

Thanks, Rory. I will investigate that. Not something I saw...

 

[James Snyder]

Rory, that was it. It must have been a copy and paste error. Much appreciated!