Mail_ActiveSheet()

[evgny]

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

 

[Ron de Bruin]

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

 

[evgny]

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

 

[Ron de Bruin]

I agree, with the third option it will always work