Logo 
Search:

MS Office Answers

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds
  Question Asked By: Lloyd Alvarez   on Nov 28 In MS Office Category.

  
Question Answered By: Abel Fischer   on Nov 28

I seem to be going in circles with trying to write an excel function. I'm
trying to create a function  that takes in a set of business rules and scheduling
constraints and outputs the results to a range  of cells but I’m unsure of the
structure of the formula.

I would like to create the public function

BusinessResults (ByVal BusinessRules As Range, ByVal BusinessConstraints As
Range) As Range



BusinessResults.Range(application.caller.address).offset(rowIndex,
ColumnIndex) = 411



Can you get me going on the right path?

Share: 

 

This Question has 9 more answer(s). View Complete Question Thread

 
Didn't find what you were looking for? Find more on How does a user defined function know its cell address? Or get search suggestion and latest updates.


Tagged: