Excel Macro to copy Excel Invoice data to Excel Database - Works Perfect. But

Following macro code is for copying Excel Invoice Data to Excel Database. Also cleans the specified cells after copying. Its working Perfectly.

But there are some issues that should be solved.

Problem 1: It copies empty cells(""), formula based cells and blank drop-down list.

Problem 2: After copying it cleans formulas too. Formulas must be remain their.

Please Login or Register  to view this content.

Solved Problem# 2

Added code (In Bold). Works Fine.

Please Login or Register  to view this content.

Problem #

If I add SpecialCells(xlCellTypeConstants)

To

Please Login or Register  to view this content.

Then it skips empty Cells, but also it results as #N/A where cells are empty and list based and has formula.

Pl. Suggest.