Michael,

Wherever this appears:
..SpecialCells(xlCellTypeConstants, 2)

Change it to:
..SpecialCells(xlCellTypeConstants, 3)

This change will make the macro work with numbers and string
constants. It will still not work with formulas, so in your data base
you can't use something like =AnotherCell.

HTH,
Bernie
MS Excel MVP

"Michael168" wrote in message
...
Hi!Bernie Deitrick,

Thank you for trynow2() macro. Everything runs fine except when the
cell value in the master contain only numeric number it gives the
run-time error '1004' again stating "No cells were found". I try to
figure out but cannot solve it myself.

e.g. Mastersheet Record

date cust1 cust2 cust3 cust4 cust5 .....etc
10/29/2003 albert robert bobby 2010 2011
10/29/2003 2020 kintown kampar robert
10/30/2003 robert bobby albert
10/31/2003 albert bobby robert niceguy

Cust cells with name are cash sales customer and with numeric number
are credit term customers. In this case how to solve this problem.
On
each individual report sheet, I would like to add in 1 more cell for
each row-no from the master sheet so that it make me easy to trace
against the mastersheet data.

Hope this will not cause you a lot of trouble.

Thanks & Regards
Michael168



------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from
http://www.ExcelForum.com/