macro pop-up to set range?
 

Hi all,

I have created a macro by recording a few things and compiling the
macro together.

I want a pop up to select the range, cos obviously recording it the
macro just put in what column i selected.

What is the code to put in a pop up box, and also to reference it in
this line..
"=IF(COUNTIF(Duplicates!C[-14],RC[-14])=1,""Y"","""")"
I want "Duplicates" to be the reference to the box, and pop up box to
be to choose a work sheet.

If this makes sense, and you can help - thanks in advance.