tubularowl
07-12-2016, 05:21 AM
Hi,
I have put together (successfully) quite a complicated Macro sequence which works well but now I have a problem that I can't solve.
I want to create a small code loop that Looks down 500 rows. If the value of the row in column AL is not equal to a specific value then I want to be able to delete cell AL in that row and then move all the data from row AM onwards one cell to the left.
If anyone knows how it is possible to do this that would be great. You may possibly know another way of doing it.
I have put together (successfully) quite a complicated Macro sequence which works well but now I have a problem that I can't solve.
I want to create a small code loop that Looks down 500 rows. If the value of the row in column AL is not equal to a specific value then I want to be able to delete cell AL in that row and then move all the data from row AM onwards one cell to the left.
If anyone knows how it is possible to do this that would be great. You may possibly know another way of doing it.