changed it to
Set Comm = Worksheets(2).Range("J12:J50")

its working now cheers!