Scottie,

Something like

Set myRange = columns(1).specialcells(xlcelltypeblanks)

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"Scottie" wrote in message
...
how would i set a range for all non empty cells in column
a on a sheet?