row 2 must be the last available row in col J.

--
Don Guillett
SalesAid Software

wrote in message
oups.com...
Don,


When I run the macro, somethings going on with the range. It's writing
values to row 1 and 2 only in column J. Any ideas on how to chg the
Set jrng for it to write J2 down to last available row?

Thanks for your help?
Mike