How do i do this? Tricky one if possible

[ParanoidAndroid]

Hi Mr Excel

I'm not sure if this is possible to do in a macro, let alone where to start but perhaps you can assist?

Basically I have a column with a range of numbers -

For example
T Column = number in the cell
ie.
T1 = 1
T2 = 22
T3 = 33
T4 = 45

Now i have a line of code
say..Formula( )

I want to plug the values into the brackets in the formula starting from the bottom entry

for example
formula(45)
formula(33)
formula(22)
formula(1)

A couple things...Column T may not have any values places in it or it may have multiple values..it is highly unlikely to be more than 20 let alone 10 rows used in column T.
It needs to be done via macro

Thanks for your help in advance

 

[ClimoC]

Dim r as range
set r = Range("T1")

Range(YourRange).Formula = "=Sum(" & r.Value & ")"

just replace 'Sum' with whatever your formula is.

If it needs to be dynamic (so updates if the value of T1 changes), then just swap the property ".Value" with ".Address"

 

[ClimoC]

Oh and don't forget to qualify your 'MyRange' properly if it goes between sheets or anything like that.

Sorry - you didn't provide much other than "The numbers are in Column T"

I should also add, if 'Blank' cells are a problem, wrap the line I gave you inside an If statement to avoid errors - i.e,

Dim r as range
set r = Range("T1")

If Not r.value = "" Then Range(YourRange).Formula = "=Sum(" & r.Value & ")"