Nevermind. I added a button and called my Macro. I'm in business. I guess I just can't change cells from a user defined function.
Thanks for your help CFCEng and IRstuff.
OK, now I see! I have to put it in as a 'sub' and run it as a macro. DUH! Can I put a button on the spreadsheet that will run the macro when I click it?
Thanks again
CFSEng,
Thanks for the feedback. What you described works, as I mentioned in my original post. However, you mention "you can't change the value of other cells with a user defined function". That is exactly what I want to do. IRstuff said it worked on his computer.
I ran the function in the VB...
I read through the 'help' a lot, and found stuff on the web, before posting this thread. I learned that there are a lot of different syntax options to set the value of the cell (short cut, 'workbook', 'worksheet', cell, range, A1 notation, etc). I tried them all (really just reaching for...
Thanks a lot for trying it out. That's interesting. I thought it should work! From 'Help About', I'm using Excel 2003 (11.8142.8132) SP2. I wonder if there's a problem with this version (I doubt it), or I wonder if I don't have something configured correctly? Maybe an add-on or something?
Maybe...
I'm a newbie to Visual Basic on Excel. I wanted to do a very simple task, and have wasted a couple hours trying. I'm hoping somebody can help. Here is a very simple function, but I get #Value error when I use it.
Function Test()
' The following doesn't work - I get a # Value error: WHY...
