HI
(microsoft.public.excel.programming)
I am working on a excel sheet that works as per below pattern.
I have two sheets namely LI and Looks_Like.
I have 10 cells in Looks_llike sheet that are referenced to 10 cells
from LI sheet. Which means on Populating the cell A1 in LI sheet
cell A1 in Looks_like sheet gets populated with the same value.
now my question is, Now if i have only 5 cells populated in LI sheet
and the other 5 are empty, how do i delete the rows in which the
blank cells of Look_like sheet are present that are referenced to
these empty
cells in LI.
Can it be done using
VB code If yes... I will be gr8ful if you can
help mew with the code.