Assigning values to adjacent cells from a function

M

MJ_N_CO

I have a function that takes 6 variables and calculates 5 values. I need to
place all 5 values to adjacent cells so they can be used in other comparisons
and calculations. I have tried using the ActiveCells.Offset(R,C).Value = X,
and get a #Value! error. Is there a way to do this? I could do this as 5
separate functions, but since a large portion of the code would be
repetitive, this would be inefficient.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Using COUNTIF with criteria in an adjacent column? 5
XIRR non adjacent cells 2
Adding data only if adjacent to cell labeled "male"/"female" 1
Get highest value and adjacent cell value 12
Identify adjacency cells with same value 3
Excel Countif Function - Calculating Between Two Sets of Values 3
Help with Address(), Indirect(), Offset 2
Sum of cells based on entry of adjacent cell 2

Top