H
Helmut
I want to execute the following until the cell in Column E is EMPTY.
Range("E11").Select
ActiveCell.FormulaR1C1 = "=+jan!RC+jan!RC[2]" (where jan is the
'PREVIOUS' sheet
Range("G11:H11").Select
Selection.ClearContents
Range("E12").Select
ActiveCell.FormulaR1C1 = "=+éðåà ø!RC+éðåà ø!RC[2]"
Range("G12:H12").Select
Selection.ClearContents
Range("E13").Select
Range("E11").Select
ActiveCell.FormulaR1C1 = "=+jan!RC+jan!RC[2]" (where jan is the
'PREVIOUS' sheet
Range("G11:H11").Select
Selection.ClearContents
Range("E12").Select
ActiveCell.FormulaR1C1 = "=+éðåà ø!RC+éðåà ø!RC[2]"
Range("G12:H12").Select
Selection.ClearContents
Range("E13").Select