How can write this as workbook function ???
 

How can write this as workbook function ???

("Sheet1 ").Range("D" &
aWS.Range("A16").Value & "").Value

it would be something like this
]Sheet1'!$D$ ^^^thisworkbook.A16.value^^^

and how would it be inside an IF function , requiring that value = zero (for
example!)

tx if can help me about
paolo

How can write this as workbook function ???
 

I think this is what you are wanting. Hope this helps! If so, let me know,
click "YES" below.

]Sheet1!$D$"&A16="0","True", "False")

--
Cheers,
Ryan


"pls123" wrote:

How can write this as workbook function ???

("Sheet1 ").Range("D" &
aWS.Range("A16").Value & "").Value

it would be something like this
]Sheet1'!$D$ ^^^thisworkbook.A16.value^^^

and how would it be inside an IF function , requiring that value = zero (for
example!)

tx if can help me about
paolo

How can write this as workbook function ???
 

tx ryan !!
it was exactly this..

]Sheet1'!$D$"&A16=A20)

happy weekend !
paolo


"Ryan H" wrote:

I think this is what you are wanting. Hope this helps! If so, let me know,
click "YES" below.

]Sheet1!$D$"&A16="0","True", "False")

--
Cheers,
Ryan


"pls123" wrote:

How can write this as workbook function ???

("Sheet1 ").Range("D" &
aWS.Range("A16").Value & "").Value

it would be something like this
]Sheet1'!$D$ ^^^thisworkbook.A16.value^^^

and how would it be inside an IF function , requiring that value = zero (for
example!)

tx if can help me about
paolo

How can write this as workbook function ???
 

exactly...

cant find the real syntax with parenthesis and other...
i will make some try tx !!

paolo





"pls123" wrote:

tx ryan !!
it was exactly this..

]Sheet1'!$D$"&A16=A20)

happy weekend !
paolo


"Ryan H" wrote:

I think this is what you are wanting. Hope this helps! If so, let me know,
click "YES" below.

]Sheet1!$D$"&A16="0","True", "False")

--
Cheers,
Ryan


"pls123" wrote:

How can write this as workbook function ???

("Sheet1 ").Range("D" &
aWS.Range("A16").Value & "").Value

it would be something like this
]Sheet1'!$D$ ^^^thisworkbook.A16.value^^^

and how would it be inside an IF function , requiring that value = zero (for
example!)

tx if can help me about
paolo