Hi,

Thanks for the answer.
I'm trying to write a udf to calculate a cell or cell group width in cm. if .zoom property of PageSetup class not set to a logical value, I can calculate the width of cells in centimeter with the zoom ratio to see how it looks like on printout. The problem is if .zoom property set to false, I can not get the zoom ratio from PageSetup because it is calculated on fly.

I think, I give writing udf up and return to use workbook events.

Thanks a lot again....

--
HA
"okaizawa" , haber iletisinde ?unlar? ...
Is there any way to use that code in a User Defined Function.
I don't think it is possible in a cell formula.
how about Worksheet_Change or Worksheet_Calculate?

http://msdn.microsoft.com/library/en...HV05199719.asp
http://msdn.microsoft.com/library/en...HV05199619.asp

--
HTH,
okaizawa

HA wrote:
Hi,

Thanks for the code. I have one more question.

Is there any way to use that code in a User Defined Function.

thanks in advance...