Firmin,
De functie moet je
in een module plaatsen.
Meer info zie :
https://www.cpearson.com/excel/sheetref.htmGetting The Value Of A Cell On The Previous Worksheet
The following function will return the value of the specified cell on the previous worksheet. Addr is a string that may be either the address of a cell or the name of a defined name.
Function RefOnPrevSheet(Addr As String) As Variant
Application.Volatile True
With Application.Caller.Parent
If .Index = 1 Then
RefOnPrevSheet = _
.Parent.Worksheets(.Parent.Worksheets.Count).Range(Addr).Value
Else
RefOnPrevSheet = .Previous.Range(Addr).Value
End If
End With
End Function
You can use this function to get the value of C5 on the previous worksheet:
=RefOnPrevSheet("C5")zet op bv Blad2 (of eventueel aanpassen) in cel C5 een waarde.Note that the "C5" is passed in quotes, as a string, rather than a range reference.
Pierre