read my post :)

is says: "to get non-blank in column A "


--
keepITcool
| www.XLsupport.com | keepITcool chello nl | amsterdam


William wrote :


For the benefit of the OP, he should change the [a:a] in your code to
something like [a:iv] or use the used range.