P
Peer
I've quite a problem I think.
I've made a userform in which the name of a new sheet can be defined
as follows:
Dim ws As Worksheet
Set ws = Worksheets.Add
ActiveSheet.Name = postnaam.Text (postnaam is the name I've given t
the textbox in which the name of the sheet is defined by user)
Later on I want to fill in a formula in another (total calculation
sheet with a reference to the new sheet, for example:
worksheets("total sheet").range("D8").formula = "='name of th
sheet'!$D$8
The problem I now encounter is that I don't know which name the use
will use for his new sheet, so I can't make an absolute reference, ye
this is what excel needs for automatically updating the value in tha
cell.
Please help me with this problem, I can't find a solution!
tnx in advance,
Pee
I've made a userform in which the name of a new sheet can be defined
as follows:
Dim ws As Worksheet
Set ws = Worksheets.Add
ActiveSheet.Name = postnaam.Text (postnaam is the name I've given t
the textbox in which the name of the sheet is defined by user)
Later on I want to fill in a formula in another (total calculation
sheet with a reference to the new sheet, for example:
worksheets("total sheet").range("D8").formula = "='name of th
sheet'!$D$8
The problem I now encounter is that I don't know which name the use
will use for his new sheet, so I can't make an absolute reference, ye
this is what excel needs for automatically updating the value in tha
cell.
Please help me with this problem, I can't find a solution!
tnx in advance,
Pee