hello all
im trying to clear some cells using VBA
the first ones work on the run to product line , but why cant i get the others to work?
do i need a link or somthing to link them together ?
many thanks jason
im trying to clear some cells using VBA
the first ones work on the run to product line , but why cant i get the others to work?
do i need a link or somthing to link them together ?
Code:
'RUN TO PRODUCT
Range("J25,J38,J51,J64,J77,J90,J103,J116,J129,J142,J155,J168,J181,J194,J207").Select
Selection.ClearContents
'CLEAR COMMENTS
Range("J24,J37,J50,J63,J76,J89,J102,J115,J128,J141,J154,J167,J180,J193,J206").Select
Selection.ClearContents
'CLEAR COMMENTS
Range("J23,J36,J49,J62,J75,J87,J101,J114,J127,J140,J153,J166,J179,J192,J205").Select
Selection.ClearContents
many thanks jason