Excel: VBA range, b cells, correct syntax

Secondly it is very very rare to have to select a cell or a range in VBA before your code does anything to that cell or range. My suggestion is to do it this way because I think it is easier to understand FinalRow = Range("B65536").End(xlUp).Row-9 'to acc

en.allexperts.com