Using a Macro copy paste

  • Thread starter Thread starter bkpatel2000
  • Start date Start date
B

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,"D1:D4 text file is past in C1:C4","")

if possible

Bhavesh.Patel
 
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
 
Back
Top