Expected:= ???

[Zurn]

When I write the lines
PutOnReport("B" & leftChoise * 22 - 15, "A5")
PutOnReport("B" & rightChoise * 22 - 15, "M5")

I get the message:

COMPILE ERROR:
EXPECTED:




PutOnReport is a method (sub made by) that puts values from two test
on sheet 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

 

[Rob Bovey]

Does it work if you call your subroutine like this:

PutOnReport "B" & leftChoise * 22 - 15, "A5"
PutOnReport "B" & rightChoise * 22 - 15, "M5"

The parenthesis are not allowed in the syntax you used below.

--
Rob Bovey, MCSE, MCSD, Excel MVP
Application Professionals
http://www.appspro.com/

* Please post all replies to this newsgroup *
* I delete all unsolicited e-mail responses *