| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Changing spreadsheet cell through UDF
Hi Nacho.
a UDF returns a value it cannot change another cell. --- Regards, Norman "Nacho Nachev" wrote in message ... 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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Changing spreadsheet cell through UDF
Well, and is there any workaround possible?
Thanks, Nacho "Norman Jones" wrote in message ... Hi Nacho. a UDF returns a value it cannot change another cell. --- Regards, Norman "Nacho Nachev" wrote in message ... 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 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Changing spreadsheet cell through UDF
Hi Nacho,
Depending on your situation, you may be able to use a Worksheet_Change procedure. --- Regards, Norman "Nacho Nachev" wrote in message ... Well, and is there any workaround possible? Thanks, Nacho "Norman Jones" wrote in message ... Hi Nacho. a UDF returns a value it cannot change another cell. --- Regards, Norman "Nacho Nachev" wrote in message ... 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 |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Changing spreadsheet cell through UDF
Yes, that's seems possible option. Thank you!
Nacho "Norman Jones" wrote in message ... Hi Nacho, Depending on your situation, you may be able to use a Worksheet_Change procedure. --- Regards, Norman "Nacho Nachev" wrote in message ... Well, and is there any workaround possible? Thanks, Nacho "Norman Jones" wrote in message ... Hi Nacho. a UDF returns a value it cannot change another cell. --- Regards, Norman "Nacho Nachev" wrote in message ... 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Spreadsheet changing currency format | Excel Discussion (Misc queries) | |||
| Changing background colour when changing data in a cell | Excel Discussion (Misc queries) | |||
| Changing a whole spreadsheet to proper case | Excel Discussion (Misc queries) | |||
| Changing a cell value in a spreadsheet may not change the result. | Excel Discussion (Misc queries) | |||
| changing existing spreadsheet | Excel Programming | |||
Hybrid Mode
