View Single Post
  #2   Report Post  
Don Guillett
 
Posts: n/a
Default

maybe

activecell.

format(activecell,"yourformathere")

--
Don Guillett
SalesAid Software

"vbphil" wrote in message
...
I've written a VBA function that will be used on a worksheet as a

worksheet
function. I want to modify the formatting of the cell that the function is
in. I haven't found any way that works. How do you reference the cell that
the formula is in and make changes to it?

Thanks, -phil
--
no place like 127.0.0.1