When you record a macro, the default is always "Cells". You want to changethat to "Range" or "Selection".