Hello saban,

Can you post a sample workbook? It will be easier for me to see where the code fails you and how to solve it.

Rembo


Quote Originally Posted by saban
for that add data i wrote: [VBA] Worksheets(i).Range("A3").Activate [/VBA]
but i get error activate method of range class failed