Hello -- Looking for VBA code to read a variable (say, in cell A1), which corresponds to one of 30-40 range names on the same sheet, then copy that range and paste-special-values into another range on another sheet, also corresponding to that same variable. Any ideas? Thanks....