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

--
Message posted from http://www.ExcelForum.com