![]()
Option Explicit Sub sAddFormula() Dim lLR As Long With Sheets("Output") lLR = .Range("A" & .Rows.Count).End(xlUp).Row .Range("F2:F" & lLR).Formula = "='Export Freshbooks'!I2*'Export Freshbooks'!J2" End With End Sub
Regards, TMS
![]()
Option Explicit Sub sAddFormula() Dim lLR As Long With Sheets("Output") lLR = .Range("A" & .Rows.Count).End(xlUp).Row .Range("F2:F" & lLR).Formula = "='Export Freshbooks'!I2*'Export Freshbooks'!J2" End With End Sub
Regards, TMS
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
Wow okeey thank you
But on my Sheets its still #Value.. can it be a bug in my excel??
The VBA line works its fills in the cells ....
Should i post my current file?
Thanks,
Last edited by Shimazu; 02-23-2014 at 06:14 PM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks