Macro to delete erroneous data in spreadsheet

I would like to be able and sort by column G and expand to all columns and have macro delete all rows with data that is equal to -995.25 then go back and sort column c back from oldest to newest with expanded ranges so I am back to where I started.

Can this be done.

If you are going to sort one way just to sort back to the original do you even need to sort at all? If you are just trying to delete all rows in column G where the value is = -995.25 this will do the trick:

Please Login or Register  to view this content.

Thanks I'll have to try it later