J
johan
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.
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.