How many Cell is filled in Row

Having the ability to check the length of Row will give you the option to run script for the list of items in your EXCEL spreadsheet

Here we are checking the current Spreadsheet’s Row A length and declared “LastRow” for future reference

With ActiveSheet

LastRow = .Cells(.Rows.Count, "A").End(xlUp).Row

End With