OldSwimmer1650
New Member
- Joined
- Dec 3, 2020
- Messages
- 27
- Office Version
- 365
- Platform
- Windows
The change is from $E$2 to $E$3 & $B$2 to $B$3
This formula changes from:
=IFERROR(SUM(FILTER('Garmin Data'!$E$2:$E$5000,ROUNDDOWN('Garmin Data'!$B$2:$B$5000,0)=D324)),"")
to
=IFERROR(SUM(FILTER('Garmin Data'!$E$3:$E$5000,ROUNDDOWN('Garmin Data'!$B$3:$B$5000,0)=D324)),"")
after the below code executes
Windows("Weight_Ex.xlsm").Activate
Sheets("Garmin Data").Select
Range("A2").EntireRow.Select
Selection.Insert Shift:=xlDown
Range("A1").Select
Application.CutCopyMode = False
I know the insert is causing the error, but I don't know how to fix it.
This formula changes from:
=IFERROR(SUM(FILTER('Garmin Data'!$E$2:$E$5000,ROUNDDOWN('Garmin Data'!$B$2:$B$5000,0)=D324)),"")
to
=IFERROR(SUM(FILTER('Garmin Data'!$E$3:$E$5000,ROUNDDOWN('Garmin Data'!$B$3:$B$5000,0)=D324)),"")
after the below code executes
Windows("Weight_Ex.xlsm").Activate
Sheets("Garmin Data").Select
Range("A2").EntireRow.Select
Selection.Insert Shift:=xlDown
Range("A1").Select
Application.CutCopyMode = False
I know the insert is causing the error, but I don't know how to fix it.