M
Mohan
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.
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.