Changing spreadsheet cell through UDF

  • Thread starter Thread starter Nacho Nachev
  • Start date Start date
N

Nacho Nachev

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 here:

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
 
Hi Nacho,

Depending on your situation, you may be able to use a Worksheet_Change
procedure.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

UDF Looks for Named Range Not Function 2
Spreadsheet translation 8
function with more functionality then typical UDFs? 9
UDF in Excel 2007 for Filter or Query 2
Add-In UDF returning #NAME error 5
Can UDF modify worksheet(s)? 5
Print spreadsheet replacing recipient name 4
change cells when a particular user makes her input 1

Back
Top