Recent content by canfresca

Great, That works perfectly. And thanks for the Step 3 info. I was try to add three before and it wasn't working. Thanks.

Basically I want to treat every 3 cols independently Col 1 Col 2 Col 3 Col 4 Col 5 Col 6 x -1 x x x x x -1 x x x x x -1 x x x x x x x -1 x -1 col 1,4 (and other multiples) all...

One more thing. This code works only in column B, is there anyway to get it to loop through more columns? (My sheet goes up to DA)

Thanks so much!

And no, I don't want to delete the entire row, just the -1 value and the value left of it and then shift all other values up.

So for example: 0.89 -1 0.895 -1 0.9 -1 0.905 1.146 0.91 1.148 0.915 1.1397 0.92 1.139 0.925 1.1545 0.93 1.1229 I want to delete the cells in column 1 and 2 for the first three because they have -1 values. And yes there are over 300 rows and about 100 columns of data

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...