View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Nacho Nachev Nacho Nachev is offline
external usenet poster
 
Posts: 26
Default Changing spreadsheet cell through UDF

Hello,

I have some problem with a VBA function that I use within a formula. What is
special about my function is that it also should modify particular cell in
the current spreadsheet. However it does not work. My fragment of code
dealing with this is he

Application.ActiveSheet.Cells(49, 3) = 10

I have also tried other approaches but with no luck. Neither the
spreadsheet, nor the cell are protected.

Is there any workaround for this problem?

Thank you for your time,
Nacho