Further to the above, i changed the .delete for .select and set the line after as a break point so I could see what was happening and it selected ALL cells (to be deleted), so I think the problem is with the 'With' range?
Further to the above, i changed the .delete for .select and set the line after as a break point so I could see what was happening and it selected ALL cells (to be deleted), so I think the problem is with the 'With' range?
Bookmarks