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.