In my version of Excel (which is oriented Left to Right), h1 is to the left
of BZ1. I would do

Range("I1",cells(1,"IV").End(xltoLeft)).Entirecolu mn.Select

are you using a right to left version of Excel?

--
Regards,
Tom Ogilvy

"Darin Kramer" wrote in message
...
Thanks tom - Slight modification - Ive changed a1 to bz1. works fine,
but now I want to select the columns that my range has identifed (ie
currently selecting from bz1 until last piece of data assume h1 - so its
selecting bz1 to h1. I want to select the whole column BZ to I (not H!)
(ie the one next to H and also the whole column not just row 1

Thanks!!



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