View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Ryan H Ryan H is offline
external usenet poster
 
Posts: 489
Default 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