Variables

[Deepjuillet]

Hi I have an excel sheet that names a number of cells as variables. For example cell A1 is defined as speed and in formulas elsewhere in the workbook I have used speed in formulas rather than A1.

I now want to write a function in VBA that uses speed in a formula. Rather than referring to A1, I want to know if I can use the named variable (speed) in the module. When I wrote the code and ran debugger it showed no error but returned zero as result.

Is this possible? I can always to the calculations in the workbook itself but thought I’d try developing a function and use that instead.

 

[rollis13]

This is just a very simple example for cell A1 defined as speed, if you need a Function it wouldn't be much different.

Sub test()
    Range("B1") = Range("speed") * 250
    Range("B2").FormulaR1C1 = "=speed*250"
End Sub