| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how do you write format results of a function within a function? | Excel Worksheet Functions | |||
| How to write to the VBE of a closed workbook? | Excel Programming | |||
| Sum data in workbook 1 and write result in workbook 2 | Excel Programming | |||
| how do I write a vlookup function within an iserror function so t. | Excel Worksheet Functions | |||
| Write no closed workbook ? | Excel Programming | |||
Linear Mode
