Hi,

When calling a macro from a cell in excel, how can I set the format of
that cell to use for instance Date dd.mm.yyyy ? Do I need to supply
location of the cell I want to format (using Range?) ? Would
appreciate any example.

Thanks.