Hi

I youse Ron De Bruin Mail_ActiveSheet(), it works fine, but I use
ISOWeek function in the original workbook and I got an Error wher the
function is plaised in the copy`d sheet.
Is there a workaround that problem.

Regards
Yngve

Hi evgny

You can make values of your formulas if this is possible or use my Add-in that
have a option (workbook special) that will make a copy of the workbook with only the sheets you want.

Another way is to use a worksheet function like this (it will not need the function)
http://www.rondebruin.nl/weeknumber.htm#formulas




--
Regards Ron de Bruin
http://www.rondebruin.nl


"evgny" wrote in message oups.com...
Hi

I youse Ron De Bruin Mail_ActiveSheet(), it works fine, but I use
ISOWeek function in the original workbook and I got an Error wher the
function is plaised in the copy`d sheet.
Is there a workaround that problem.

Regards
Yngve

Thank`s alott

The 3 option I think I will use, that will stay in the copy`d
sheet, best solution for me.

Menny regards

Yngve

I agree, with the third option it will always work


--
Regards Ron de Bruin
http://www.rondebruin.nl


"evgny" wrote in message oups.com...
Thank`s alott

The 3 option I think I will use, that will stay in the copy`d
sheet, best solution for me.

Menny regards

Yngve