This code return error Wrong number of arguments or invalid property assignment: _Default
- Public Sub ReCalculate_acepted_contacts()
- i=10
- j=2
- 'это шаблон заполнения
- Sheets("Сводная").Cells(i, j).Value = get_acepted_contacts(Sheets("Сводная").Cells(i,i))
- End Sub
But this code is work correct
- Public Sub ReCalculate_acepted_contacts()
- i=10
- j=2
- 'это шаблон заполнения
- Sheets("Сводная").Cells(i, j).Value = get_acepted_contacts(Sheets("Сводная").Cells(10,2))
- End Sub
In first example my function use variables (i,j). Another example show using 10 and 2.
How i can solve this problem and use
variables in cell adress without errors.