How to skip blank tabs of cell while using macro

Hi,

I am new to Excel macro programming.
I have created a macro which copy values from different cell and copy them in append mode to some cell.
I am able to copy all values but facing problem when there is blank cell between the two cells.
I have attached the excel file.

The cell with value problem is not being populated in ADD cell.
Can any body tell me how to skip the blank cells

Thanks

Please Login or Register  to view this content.

hI
Try this macro
ravi

Thanks for help