Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Sub, not function!
Still I get the message: COMPILE ERROR: EXPECTED: PutOnReport("B" & leftChoise * 22 - 15, "A5") PutOnReport("B" & rightChoise * 22 - 15, "M5") PutOnReport is a method that puts values from two tests on shee Report, one test on the left, another on the right. LeftChoise is the test chosen to be on the left, rightchoise on th right A5 is the cell on sheet Report where data from the leftchoise has to b put, M5 for the right choise. *why do I get this message and how correct it? -- Zur ----------------------------------------------------------------------- Zurn's Profile: http://www.excelforum.com/member.php...fo&userid=1464 View this thread: http://www.excelforum.com/showthread.php?threadid=26374 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Sub, not function!
When calling a Sub procedure, don't enclose the arguments in
parentheses. E.g. change PutOnReport("B" & leftChoise * 22 - 15, "A5") ' to PutOnReport "B" & leftChoise * 22 - 15, "A5" -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "Zurn" wrote in message ... Still I get the message: COMPILE ERROR: EXPECTED: = PutOnReport("B" & leftChoise * 22 - 15, "A5") PutOnReport("B" & rightChoise * 22 - 15, "M5") PutOnReport is a method that puts values from two tests on sheet Report, one test on the left, another on the right. LeftChoise is the test chosen to be on the left, rightchoise on the right A5 is the cell on sheet Report where data from the leftchoise has to be put, M5 for the right choise. *why do I get this message and how correct it?* -- Zurn ------------------------------------------------------------------------ Zurn's Profile: http://www.excelforum.com/member.php...o&userid=14645 View this thread: http://www.excelforum.com/showthread...hreadid=263742 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel Data Validation/Lookup function does function correcty | Excel Worksheet Functions | |||
copy of excel file not showing formulal/function in the function b | Excel Discussion (Misc queries) | |||
LINKEDRANGE function - a complement to the PULL function (for getting values from a closed workbook) | Excel Worksheet Functions | |||
Offset function with nested match function not finding host ss. | Excel Worksheet Functions | |||
Emulate Index/Match combo function w/ VBA custom function | Excel Worksheet Functions |