Pinned Loading

1. Useful VBA code Useful VBA code

   1

   Public Function nRows(ws As Worksheet, c As Long) As Long

   2

       ' nRows return the number of rows on column 'c' from ws worksheet

   3

       nRows = ws.Cells(ws.Rows.Count, c).End(xlUp).Row

   4

   End Function

   5