Displaying the value of a VBA variable in the excel workbook

Hi there!
I would like to be able to do this: Data is enterred into varius cells in excel, then a sub does something with those, and a numerical value for variable X is found. Is there a way to display the value of X in the active cell in the workbook? I understand this would be much easier to do with just a simple user-defined function, but I am doing this for a class, and the instructions are to do this with a sub specifically. Kind of odd I think, but there it is.
Any tips would be appreciated!

Thank you, that helps - although not exactly what I need to do.
The data is from an array that the user selects in the workbook (for example A1:B3)
and you get a number, X - which must be displayed in a cell two columns to the right of the farthest right column of the select aray.

Please Login or Register  to view this content.

But rather than it be in put in A1, it needs to be in the active cell, selected in the line above. This may not be a good approach in the first place though, so I'm open to other ways of doing this!