<div>
Didn't see your other question directly connected to this one and the answer given by cri.<br />
<br />
It wasn't necessary to ask a new question, you should just have added a comment to the first question you asked, and I'm sure cri would have given you the satisfactory answer.<br />
<br />
In fact the answer I gave is exactly the same as cri's, I just introduced the right characters on the right place responding to your new question.<br />
<br />

</div>


Didn't see your other question directly connected to this one and the answer given by cri.

It wasn't necessary to ask a new question, you should just have added a comment to the first question you asked, and I'm sure cri would have given you the satisfactory answer.

In fact the answer I gave is exactly the same as cri's, I just introduced the right characters on the right place responding to your new question.



<div>
If this answers your needs, two options:<br />
<br />
&nbsp; &nbsp; 1. Give cri the points and ask EE to delete this question<br />
&nbsp; &nbsp; 2. Give us both the points if you feel we both helped<br />
<br />
If you're still not 100% satisfied, add your additional questions as a comment in one of both questions and ask to delete the other one.<br />
<br />
Bye, Geert
</div>


If this answers your needs, two options:

    1. Give cri the points and ask EE to delete this question
    2. Give us both the points if you feel we both helped

If you're still not 100% satisfied, add your additional questions as a comment in one of both questions and ask to delete the other one.

Bye, Geert

<div>
<div class="content wysiwyg-content">
For the following function<br />
IF(Sheet1!M6&gt;0,Sheet1!M6,&quot;<wbr /> &quot;)<br />
<br />
Can you please tell me what the exact format would be for the use of Indirect to replace 6 in the expression above with a value that is in cell U5.<br />
<br />
Thanks
</div>
</div>


For the following function
IF(Sheet1!M6>0,Sheet1!M6," ")

Can you please tell me what the exact format would be for the use of Indirect to replace 6 in the expression above with a value that is in cell U5.

Thanks

Use of Indirect in Excell

Microsoft Office is an integrated suite of applications that includes Outlook, Word, Excel, Access, PowerPoint, Visio and InfoPath, along with a number of tools to assist in making the individual components work together. Coding within and between the projects is done in Visual Basic for Applications, known as VBA.