Joel's code should work fine provided that row 20 is the last row of data in
column A. If not and you just want to process the 20 rows then change the
following line of Joel's code.

Replace this
LastRow = .Range("A" & Rows.count).end(xlup).row
with this
LastRow = 20

--
Regards,

OssieMac


"K" wrote:

Hi OssieMac, Thanks for replying. Yes A20 will always be the last
cell and it will be alwasy column A