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 ***