How can i convert the following to range type?
Cells(OldTargetRow, 1) to Cells(OldTargetRow, 50)

I want to use the WorksheetFunction.CountA .
Since this function takes range as variable i must somehow convert Cells(OldTargetRow, 1) to Cells(OldTargetRow, 50)
to range.

can anyone help me with this?

Thank you.