Runime Error 1004 Method Range of Object Global Failed
 

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

Runime Error 1004 Method Range of Object Global Failed
 

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

--
Regards
Frank Kabel
Frankfurt, Germany

"Mohan" schrieb im Newsbeitrag
...
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

Runime Error 1004 Method Range of Object Global Failed
 

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!

Runime Error 1004 Method Range of Object Global Failed
 

Hi
does the defined name exit and how is your variable defined

--
Regards
Frank Kabel
Frankfurt, Germany

"Ganesh Mohan Nagarajan" schrieb im
Newsbeitrag ...

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!