I have a user form that pops up and the user selects various things and
then hits a save button to record all the selections made to a
worksheet. I then set a worksheet range to that row where the data was
just entered.
My problem is that this new range area does not seem to be updated and
available when it gets set. I have a print button on the user form that
hides the initial form and displays a worksheet. The work sheet uses
formulas like: =INDEX(Print_Range,1,8) to get cell values from this
print range that was supposedly just defined. I put several msgboxes
in my code to see what the range("Print_Range").Name is set to and it
comes back with the correct range but when my worksheet is shown the
"Print_Range" range has not been updated to the new row.
The bizarr thing is that when I rerun the user form and genereate a new
line of info and set the "Print_Range" to this new line it all works
fine. The Print button on my user for runs the same code again for a
second time and all is well.

Is there something that I have to refresh or recalculate on the
worksheet that will make it accept this new range reference? Or is
there something with just hiding the user form and not unloading it for
this range change to take effect.

THanks
Scott