Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations John Tel on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Deleting cells with specific values
I'm trying to write a macro that will look at a cell value, and if the value is -1, I want it to delete that cell plus the cell to the left of it. (The two data colums go together) 1)How to I make the If statement saying "If cellval = -1" 2)How do I select that cell (and the one left of it) to...- canfresca
- Thread
- Replies: 12
- Forum: VBA Visual Basic for Applications (Microsoft)
