Thread
:
If data exists in column J, put formula in column K
View Single Post
#
6
Posted to microsoft.public.excel.programming
S Himmelrich
external usenet poster
Posts: 76
If data exists in column J, put formula in column K
Solution:
Dim rng As Range
Set rng = Range(Cells(1, "D"), Cells(Rows.Count, "D").End(xlUp))
rng.Offset(0, 7).Formula = "=IF(J1="""","""",SUM(J1/MACRO!$G$11))"
Reply With Quote
S Himmelrich
View Public Profile
Find all posts by S Himmelrich
If data exists in column J, put formula in column K