Ananthak275
Board Regular
- Joined
- Aug 22, 2020
- Messages
- 128
- Office Version
- 2013
- Platform
- Windows
- MacOS
This is part of a code that i keep getting an error on
Its going into each column, looking if the previous value in the column is the same as the current. All three have to be true
Error: Expected: line number or label or statement or end of statement
Its going into each column, looking if the previous value in the column is the same as the current. All three have to be true
If (source.Sheets(1).Cells(j, ColumnA).Value = source.Sheets(1).Cells(j - 1, ColumnA).Value)
AND source.Sheets(1).Cells(j, ColumnB).Value = source.Sheets(1).Cells(j - 1, ColumnB).Value
AND (source.Sheets(1).Cells(j, ColumnC).Value = source.Sheets(1).Cells(j - 1, ColumnC).Value) THEN a = 2
Error: Expected: line number or label or statement or end of statement