A
augustus
Sorry for not clarifying the question. I am trying to
generalise a function so that I could use it on a
different sheet.
Function MassPurlin(b, d) 'Looking up the mass of
purlin, in relation to b=width, d=depth in Sheet1
Firstly, b & d are two values from different cells (eg., b
from A12, d from B12). Is there some way I could write so
that I could know which cell was b from? (Ie, let say I am
reusing this formula on another sheet, and the reference b
and d is no longer at A12 & B12)
Thankyou
generalise a function so that I could use it on a
different sheet.
Function MassPurlin(b, d) 'Looking up the mass of
purlin, in relation to b=width, d=depth in Sheet1
Firstly, b & d are two values from different cells (eg., b
from A12, d from B12). Is there some way I could write so
that I could know which cell was b from? (Ie, let say I am
reusing this formula on another sheet, and the reference b
and d is no longer at A12 & B12)
Thankyou
..