Getting range from value of cell

Would you upload an example of your workbook and explain what range you expect to select with your VBA code.

Hi!

I've uploaded a very basic example using apples and pears

What I am aming to do is effectively build a macro that takes the formulas used in finding the various "differences" and
the "totals" and returns in a seperate cell what is is doing in words.

E.g. take away (june) (apples) of (150) from (may)(apples) of (152) to get (may/jun) (apples) of (2)

Where everything in (brackets) has been looked up.

I have unfortunately fallen at the first hurdle though.

I would like to know how i can take a formula from a cell and use the cells used as part of a new reference, which i can then
use .End(xlUp) to get the header (apples) and .End(xlLeft) to get the time (may).

Im thinking maybe using Trim functions could work, but with all the formulas being different, and in my real sheet having
references to cells in colum being Z and 100 might make that no longer work, i dont know though.

As you can probably guess im starting out with vba so maybe ive missed something crucial.

My very basic question is how can i use
Range(Range(Selection).Value), tried putting "" around it and it didnt like that.

Thanks

Hi,

One way is the following UDF

First name your Sheet1 range B3:D6 "Data"
Then in G4 enter the first month and in H4 the second month

Then in a cell enter the formula

Formula:

Please Login or Register  to view this content.

The 4th parameter should be eithet "M" for minus or "P" for plus

See also attached

Please Login or Register  to view this content.