Excel Macro
 

I have a excel workbook , in which there are seven
worksheets.
I am basically validating few cells in a worksheet and
populating the result in another excel. Like wise I need
to add the results in others excels by the validation
results.

Sheets("Sheetname").Select
Range(XCell).Select
ActiveCell.FormulaR1C1 = Total

I get a error message "Run time Error 1004 Method Range of
object Global failed."

Pls help. I am tired debudgging. Thanks.

Excel Macro
 

What type of variable is XCell and what does that variable
contain?



--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"Mohan" wrote in message
...
I have a excel workbook , in which there are seven
worksheets.
I am basically validating few cells in a worksheet and
populating the result in another excel. Like wise I need
to add the results in others excels by the validation
results.

Sheets("Sheetname").Select
Range(XCell).Select
ActiveCell.FormulaR1C1 = Total

I get a error message "Run time Error 1004 Method Range of
object Global failed."

Pls help. I am tired debudgging. Thanks.

Excel Macro
 

TRy this

Sheets("Sheetname").Select
Range(XCell).Value = Total

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"Mohan" wrote in message
...
I have a excel workbook , in which there are seven
worksheets.
I am basically validating few cells in a worksheet and
populating the result in another excel. Like wise I need
to add the results in others excels by the validation
results.

Sheets("Sheetname").Select
Range(XCell).Select
ActiveCell.FormulaR1C1 = Total

I get a error message "Run time Error 1004 Method Range of
object Global failed."

Pls help. I am tired debudgging. Thanks.