Boogerbut74
New Member
- Joined
- Oct 17, 2022
- Messages
- 26
- Office Version
- 365
- Platform
- Windows
So im trying to have i be put in as the end range number. the problem in my code right now is the line that is colored red
Rich (BB code):
Dim number
Set Table = Application.InputBox("please select the data range:", "Kutools for Excel", xTxt, , , , , 8)
If Table Is Nothing Then Exit Sub
For i = 2 To (Table.Rows.Count + 1)
Average_chart1 = Aplication.WorksheetFunction.Average("J2:J" + i)
Last edited by a moderator: