Dear Amar,
firstly remove refrence . simple copy the entire cell and paste it as
values .
Step 1) select the entire coloum (D) then press cltr+F.
write 0 and tick mark the option of mark entire cell content and press *
FindAll* button.
Step2) now, at down side u find all the finding references s
Dear Friends
Pls modified Code in my sheets.Only D column find 0 Value then entire Row
delete.
Regards
Amar
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM