macro pop-up to set range?

N

NPell

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Macro Help 6
Create formulas using multiple pop-up input boxes? 3
Word macro that can call cells out of Excel for a find and replace 0
Pop-up box 2
disable pop up box 2
Modify range in VBA 9
Highlight Duplicates, Macro? 6
Macro 3

Top