set myRange = Range("A1:C" & cells(rows.count,"C").end(xlup).row)

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Tempy" wrote in message
...
Good Day, I have to name a range and it can vary, dependant on the
spreadsheet recieved and the amount od data but all the used area will
be the range name KTL.

At this point in time it is A1:CQ847

This could go to CQ5000

Could somebody help me with some code please.

Thanks in advance

Tempy

*** Sent via Developersdex http://www.developersdex.com ***