A bit late but here goes:
Range("C7").Select
ActiveCell.End(xlDown).Offset(1, 0).Select 'FINDS LAST NUMBER IN
COLUMN C
--
Occasionally stumped


"Sandy" wrote:

what was the method?

Thanks

"Two-Canucks" wrote:

Sorry, found the efficient way in one of the answers.
--
Occasionally stumped


"Two-Canucks" wrote:

I need an efficient way to find the cell below the last
number in a column in a macro.
Thanks
--
Occasionally stumped