Stephen,

What you are seeing as 2 lines of code should all be on the same line.
'Feature' of the newsgroups I am afraid. Join them together, and try it
again.

--

HTH

Bob Phillips

"Ste_uk" wrote in message
...
Hiya bob,

Thanks for the response..

tried the code but it is showing a syntax in

cCols = Worksheets("Input").Cells(3,
Columns.Count).End(xlToLeft).Column


any ideas?

regards
Stephen.