The statement supposed to a output the String "Hello" to cell F2 of Sheet2, is called with a user defined function.
This is the full code
Please Login or Register to view this content.
Forum won't let me post the full code.
The Range.Value function in the 'main method' is able to output the string to the desired location in Sheet1, but can't do the same to Sheet2 as well.
It works like this:
Please Login or Register to view this content.
If I've helped you, please consider adding to my reputation - just click on the liitle star at the left.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~(Pride has no aftertaste.)
You can't do one thing. XLAdept
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~aka Orrin
Gues this is the problem:
Sheet2 is the sheet named "C Column Evaluation"Please Login or Register to view this content.
If you want it to output to the sheet named "Sheet2" then use
orPlease Login or Register to view this content.
Please Login or Register to view this content.
Cheers!
Tsjallie
--------
If your problem is solved, pls mark the thread SOLVED (see Thread Tools in the menu above). Thank you!
If you think design is an expensive waste of time, try doing without ...
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks