Right, no file no solution.
"GS" ???? ...
This sounds like a rather convoluted project that certainly could be
simplified and streamlined for better efficiency.
How many sheets in the workbook?
How many "Excel Forms" (I assume you mean Userforms)?
If multiple forms, why?
Is the facility name in 'Page 1'!C8 the same for all?
Can you upload this project so we can have a look at it?
--
Garry
Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion