If you code uses activesheet, then you are correct that that would have to
be changed.

Dim sh as Worksheet
set sh = worksheets("MyDatasheet")
then use sh instead of activesheet. Also, you can't use select and
activate on a hidden sheet, but I would assume your code has gotten beyond
the need to do that.

--
Regards,
Tom Ogilvy


"Duncan" wrote in message
oups.com...
Tom,

I tried to do this earlier, (maybe i done something wrong), the problem
is when i open up, the blank sheet i have added is the active sheet, so
when i run the form it is looking to the blank sheet which is in view
and not the sheet with the data in to add stuff to. thats the bit im
trying to avoid as i would have to figure out how to get it to refer to
the hidden sheet as there would be more than one.

for the time being i have added some lines in which hide the rows when
it starts up, unhides them to add the data, then hides them again. this
might slow it down though when i have filled around 25,000 lines (which
is what i expect to fill, hopefully)

Duncan