Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Hi all
I really don't seem to be able to come to grips with VBA I have copied this formula verbatim from a VBA text book and it doesn't work for me. Can someone please give me some guidance as to where I am going wrong. Sub CopyFormula() Dim FinalRow As Long FinalRow = Range("F65536").End(xlUp).Row Range("F14").Formula = "=IF(OR(D14="",D14=0),"",G14/D14)" Range("F14").Copy Destination:=Range("F15:F" & FinalRow) End Sub Regards to all that may help Michael M |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Find value in array | Excel Worksheet Functions | |||
Closing File Error | Excel Discussion (Misc queries) | |||
Formula for current month minus one = Quarter number in a macro. | Excel Discussion (Misc queries) | |||
Formula checking multiple worksheets | Excel Worksheet Functions | |||
Macro Formula revision? | Excel Worksheet Functions |