| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Assigning cell values within a VBA program
Why doesn't this function work
Function Zemax( Worksheets("Sheet1").Range("A1").Formula = "=2+2 Zemax = End Functio If I execute it within the IDE using F5, I get cell A1 set correctly If I comment out the second line, and call it as a function reference within the spreadsheet it sets the current cell to 3 If I don't comment it out, it doesn't set cell A1, and returns a #VALUE error What gives???? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Assigning cell values to variables | Excel Discussion (Misc queries) | |||
| Assigning cell values to return a number | Excel Discussion (Misc queries) | |||
| Assigning cell values to return a number | Excel Discussion (Misc queries) | |||
| Program for assigning work shift hours | Excel Discussion (Misc queries) | |||
Threaded Mode
