Update Sheet from Formula.

  • Thread starter Thread starter compound
  • Start date Start date
C

compound

Great day everybody.
I have a question to the Excel Gurus!

I have user defined function in the cell A1 (something lik
=myfunction() ).
I would like to insert value in to cell A2 by running this function.
For example by running
ActiveSheet.Cells(2, 1) = 5

If I do that then I get an "Application-defined or object-define
error".

Does anybody know how to get around this problem?

Any suggestions will be appreciated.
Thank you.
Compoun
 
UDF's (called from a worksheet cell) can't do much except return values to the
cell that holds the formula.

Maybe you could use a formula based on A1 or use a subroutine of some sort???
 
Thank you Dave!
The formula is A1 wouldn't work for me. I created a simpear example. I
reality everything is connected to the DB and there are lots of thing
in VB...

I've heard a long time ago that it's possible to reprogram the way th
Excel application works. I thought might be that could be the solution
 
You can program in excel--but that's following the rules of Excel and VBA. It's
not really reprogramming excel.
 
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

Using Cell Numbers in a range 6
Run a sub every time a function is used in a sheet 7
Runtime error 1004 when trying to insert formula in cells 11
Defining a range as a subset of cells in another range 12
Progressive number in different sheets 7
Need help inserting formula with macro 5
Using user-defined functions in cells 1
Dynamic Named Cell 1

Back
Top