Use a recorded macro to define the correct formulas before attempting to update them in accordance with each "0" line to calculate subs and maximum values. If you do this, a definition error will occur. FormulaR1C1 couldn't be written correctly, which is the issue. use excel 2019 pro plus. Please assist me.

Here's the code :

```Sub hesapla()
Dim zero_ındex As Integer
Dim lnn As Integer
Dim row As Integer
Dim a As Integer
Dim b As Integer
Dim Rng As Range
a = 2
b = 0
Sheet3.Activate
rown = Sheet3.Cells(Rows.Count, 1).End(xlUp).row

For a = 2 To rown

Do While Sheet3.Cells(a, 1).Value <> ""

If Sheet3.Cells(a, 1).Value = "0" Then
zero_ındex = a
b = a
b = b + 1

Do While Sheet3.Cells(b, 1).Value <> "0"
b = b + 1

Loop
lnn = b - 1

Sheet3.Range("U" & a).Select
Selection.FormulaR1C1 = "=SUMPRODUCT(MAX(((RC[-3]:R[ " & lnn & " ]C[-3]=""B"")+(RC[-3]:R[ " & lnn & " ]C[-3]=""Y""))*(RC[-2]:R[ " & lnn & " C[-2])))"

End If
a = a + 1
Loop
Next a
End Sub---
```
Mar 20, 2023 in Others 314 views

## 1 answer to this question.

Consider using a fixed template for the formula and Replace() to fill in the values.

I hope this helps you.
• 63,720 points

## In Excel Sheet how to Eliminate or Remove, Filter and copy the selected records defined in another sheet using dynamic array list (VBA Module)

I'm attempting to generate an Excel sheet ...READ MORE

## Runtime error 438 while importing data in excel from secured website using VBA

Replace With ieDoc.forms(0) .userType.Value = "1" ...READ MORE

## Converting feet & inches (e.g., "5 ft 1 in") to decimal feet using VBA or Excel

I have a database with a few ...READ MORE

## Retrieve epay.info Balance with VBA and Excel

This code should log you in, provided ...READ MORE

## How to load file to Excel Power query from SFTP site

Currently, I don't think there is a ...READ MORE

## Using VBA Excel to create a gramatically correct list

The Excel AND function is a logical ...READ MORE