Runime Error 1004 Method Range of Object Global Failed

M

Mohan

I have a workbook in which there are multiple worksheets.
I am validating the cells in a worksheet and populating
the results in another worksheet and like wise I populate
the results in others wrksheets based on the results from
the validation of the cells in a worksheet.

I get the following error "Runime Error 1004 Method Range
of Object Global Failed"

My code where I get this error is

Sheets("Sheet1").Select
Range(TotalCell).Select
ActiveCell.FormulaR1C1 = Total
 
F

Frank Kabel

Hi
how is TotalCell defined?
In addition: no need to select. The following statement would be
sufficient:
worksheets("Sheet1").Range("A1").formulaR1C1=total
 
G

Ganesh Mohan Nagarajan

I changed the code like this.
Sheets("Card & eCommerce").Range("CBCP_NumberOfOpenNCRCell").FormulaR1C1
= 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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top