Copy Array Formula
On May 15, 7:00*pm, "Bernie Deitrick" <deitbe @ consumer dot org
wrote:
Len
Dim rng2 As Range
Range("J1").FormulaArray = "=IF(ISERROR(G1-H1),G1,(G1-H1))"
Set rng2 = Range("J2", Cells(Rows.Count, 2).End(xlUp).Offset(1, 8))
MsgBox rng2.Address
Range("J1").Copy rng2
You can take out the Msgbox line...
HTH,
Bernie
MS Excel MVP
Hi Bernie,
Thanks for your code but this VBA code has to copy down the excel
array formula ( ie from J1 ) in column J depending on the last used
cells of column B, then how to rectify the code
Regards
Len
Hi Bernie,
Sorry, I was away and unable to access pc for almost a week.
Thanks, your codes work
Regards
Len
|