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.
Bookmarks