Thread
:
Calculating column based on formula
View Single Post
#
5
Posted to microsoft.public.excel.programming
S Himmelrich
external usenet poster
Posts: 76
Calculating column based on formula
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