Change value for multiply from input in sheet

[tigergutt]

Hello all,

I have a sheet were up until now I have used a formula with a fixed value. However, we now see in some instances this needs to be tweaked and it is a lot of work when not using this converter sheet we have. So basically, we have defined our "Newsubarea = (stabarea - subarea) * 0.4"

So the question:
This 0.4 value we would like to choose manually in a cell, say for example shee1 and cell L34.

How can I write this in VBA? I've done my best but no luck. Google search doesn't give answers related to my question.
Screenshot 2021-01-11 124841.png

Thanks in advance!

[millz]

Newsubarea = (stabarea - subarea) * Sheets("Sheet1").Cells(34, "L").value

[tigergutt]

Thanks millz, but for some reason this did not work. Seems like the whole calculation process stopped in the sheet completely. I don't get any errors, but there are no calculations done.

I will try and attach the sheet and see if that can help.

[millz]

You need to ensure there's some values in L34 before running the macro.

[tigergutt]

Yupp, value is there, but nothing...

[millz]

It will refer to the sheet named Sheet1, if your sheet is named otherwise then it won't work.

[tigergutt]

Doh... Yes off course I assumed we could just use "Sheet1", and not the edited tab name, but once I used that it worked.

Sorry for being so slow, and many thanks for you help and patience Much appreciated!