Hello,

Simple (?) question.
How can I set a value or a text in a specific cell on a specific sheet
without activating that sheet.
For example,.....

My active sheet is sheetname "Start" and when I activate sheetname
"Sheet2" I want registrate the text "Sheet2" in cell A1 of sheetname
"Start".

I had used :

Private Sub Worksheet_Activate() ' - activatemacro on sheet2
Sheets("START").Select
Range("A1").Select
Selection.ClearContents
ActiveCell.FormulaR1C1 = "Sheet2"
Sheets("Sheet2").Select
Range("A1").Select
End Sub

Problem now is that this a loop. I think (?) the solution is
registration on sheet "Start" without activating it, otherwise you
activating Sheet2 again... and again...

regards,
Johan.