<div>
Thanks for the feedback Teylyn<br />
<br />
How would u use vBa to complete the task - please..
</div>


Thanks for the feedback Teylyn

How would u use vBa to complete the task - please..

<div>
route, I edited my first comment before you posted your follow-up. If you still have questions, please pipe up.<br />
<br />
cheers, teylyn
</div>


route, I edited my first comment before you posted your follow-up. If you still have questions, please pipe up.

cheers, teylyn

<div>
No need to apologize. Glad that my suggestion helped. Thanks for the grade!
</div>


No need to apologize. Glad that my suggestion helped. Thanks for the grade!

<div>
<div class="content wysiwyg-content">
Hi Experts <br />
<br />
Is there a quick way to apply { formula } to a range of data as opposed<br />
To going intO each cell and hitting CRTL + SHIFT + RETURN<br />
<br />
Note - each cell in the range has a different formula in it.
</div>
</div>


Hi Experts 

Is there a quick way to apply { formula } to a range of data as opposed
To going intO each cell and hitting CRTL + SHIFT + RETURN

Note - each cell in the range has a different formula in it.

Array formula - applying { } to a range of data

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.