Hi,

Have a look at:
http://excelforum.com/showthread.php...light=broro183
This include's a link to a range of methods that Ron Debruin provide
on his page:
http://www.rondebruin.nl/delete.htm

re your issue, I don't have the solution but here's a couple o
suggestions:
1) I'd change your second range from "Dim Range As Range" to somethin
unique eg "SingleCellRange" as this may be confusing Excel.
2) I think "null" only relates to VBA variables not cell values (may b
wrong) & it shouldn't be ".cells", so it may be best to change thi
from:

If Range.Cells = "" then
to
If len(SingleCellRange.value)=0 then
or
If SingleCellRange.value = "" then

hth,
Rob Brockett
Always learning & the best way to learn is to experience..

--
broro18
-----------------------------------------------------------------------
broro183's Profile: http://www.excelforum.com/member.php...fo&userid=3006
View this thread: http://www.excelforum.com/showthread.php?threadid=55185