How do you select noncontiguous cell/range across sheets? I have no problem doing it on the same sheet, but they all work on the current sheet. If I throw in a sheet name, I get an error. I've tried Range().Select and Union so far. Susan H.