Usedrange not updating

02 Jul

NET Standard product, official support for Excel 2013 and Excel 2016, 51 new Excel functions, full conditional formatting support, enhanced workbook protection and encryption, cell gradient rendering, and more.

For my test data j Last Used returns 42 because there is some formatting on that row, and xl Cell Type Last Cell returns 39, which is the last visible row before row 42.

These VBA methods mimic pressing Ctrl and the up and down arrows.

Two VBA methods for working with the used range are Worksheet.

Used Range and the xl Cell Type Last Cell option of Special Cells.

Row ‘ ‘ last row in named range current region ‘ j Last In Region = o Sht. Row – 1 ‘ ‘ last row in Table ‘ j Last In Table = o Sht.