VBA Cell Referencing in other Worksheet
<p>On the current file I'm trying to write a macro for, I want the cell B187 on sheet titled Data9 to reference sheet 9-Benefits cell H75. How do I write this in VBA?</p>

<p>Also I'm trying to clear contents in cell A235 on the Data9 sheet. How do I write this?</p>

<p>I think this is fairly easy code but I'm a bit stuck.</p>

<p>Thanks!</p>