i forgot to add this to my other post, but since the workbook and sheet was
not specified, excel will assume it's the current workbook and current sheet,
meaning when you run the macro, it's only going to affect the selected sheet.

also, change the line
dim rng, rcell as range to
dm rng as range, rcell as range