Macro that will select range based off cell value in multiple rows

2014 CPS BC Spring STATS.xls

The attached file has a macro that finds and copies rows based off an entry in column M. It works as planned, apart from when M has a formula..

Basically, I would like the macro to work if the value in M is greater than 0.... either text or a value....

Hi Hambly,
It is assumed that the Sheet2 there in your book

Please Login or Register  to view this content.

Thanks Nilem. I'd like to just select and copy to the clipboard... I'll be pasting into another file once copied.

something like

Please Login or Register  to view this content.

Is it possible to just copy to a clipboard, as the file it's going to will change often. Also the range where it will be pasted will change..

Thanks for your help..

In this case just

Please Login or Register  to view this content.

I do not really true, that one and the same code will work equally in Windows and Mac

Thanks again nilem. The below code seems to work best. I don't think the Mac liked the Auto Filter one... The only thing the below doesn't do, is it won't work if M has a formula... but I can work around that...

Please Login or Register  to view this content.