Okay my bad, is there a way.of just finding the last cell without having a filter in the macro? then i could manually change it?