Thanks so much Sintek! this is what I needed, just getting the following error when I run it though
I know it has to do with Range, but B:G is the range on the sheet, so don't understand why it's doing this.Run-time error '1004' : Method 'Range' of object'_Global' failed
Bookmarks