Would it be easier to input the named range into the array,if the value is zero then delete that complete row of the array and finally store the array into the listbox?