I changed the code like this.
Sheets("Card & eCommerce").Range("CBCP_NumberOfOpenNCRCell").Form ulaR1C1
= Total_Number_Of_CPCP_Open_NCR

I still get a diffetn erorr
Application defined or object defined error

Actually I am polpulating the data value to other excels from column 1
to column X based on the month.
If the month was 1 then it would be pasted on column 1 and so on.
My CBCP_NumberOfOpenNCRCell will change as per the month to different
column in the worksheets.
This is done for other company in others worjsheets in the same
worksbook.


*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!