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

--
Zur
-----------------------------------------------------------------------
Zurn's Profile: http://www.excelforum.com/member.php...fo&userid=1464
View this thread: http://www.excelforum.com/showthread.php?threadid=26380

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 *


"Zurn" wrote in message
...

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 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=263805