Using a Macro copy paste

[bkpatel2000]

Sir,
I want to use macro in if function
in A1 Cell 10 is return in C1 Cell there is IF function
like =IF(A1=10,"D14 text file is past in C1:C4","")

if possible

Bhavesh.Patel

 

[Chip Pearson]

Formulas cannot perform any action; they can only return a value
to the cell containing the formula. The same holds for function
written in VBA that are called from worksheet cells. These
functions can not modify the Excel environment in any way,
including changing values of other cells.

You'll have to write a formula C1:C4. E.g.,

=IF($A$1=10,D1,"")

Enter this in C1 and copy down to C4.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com