IlarioAstino
08-14-2010, 12:59 PM
Hi everybody! Saturday night, instead of talking ladies I am having the following problem:
- I have say this macro in personal.xls:
sub addtest(a, b)
b = a * 3
end Sub
- from a different workbook (say testbook.xls) I am calling the procedure as follows:
aaa = 3
application.run "personal.xls!addtest", aaa, bbb
...and I receive an "empty" value in bbb!!
any clue what I am messing up?
- I have say this macro in personal.xls:
sub addtest(a, b)
b = a * 3
end Sub
- from a different workbook (say testbook.xls) I am calling the procedure as follows:
aaa = 3
application.run "personal.xls!addtest", aaa, bbb
...and I receive an "empty" value in bbb!!
any clue what I am messing up?