Defining Range with Cells property

Hi all,

I am trying to define a range (in column N) using the Cells property, so I can later use that range to iterate through it looking for empty cells and filling them.
As the range I want to analyze (in column N) contains empty cells, I use the range in column B to obtain the number of the last row from the table (=last non empty row)
The number of the last non empty row in column B (rownumber) is used as an argument in the Cells property used to define the range in column N.

However, the current way the range is defined in my code gives me the following error:

Run-time error '91':
Object variable or With block variable not set

Could you please help me identify what I am doing wrong?

Many thanks for your help!

PS: I cannot paste the VBA code here cause the forum does not allow me. Sorry :/

Something like

Please Login or Register  to view this content.

You need to use Set with objects, and you need to qualify Cells with the same sheet as the Range property, so:

Please Login or Register  to view this content.

or:

Please Login or Register  to view this content.