Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro Range | Excel Discussion (Misc queries) | |||
Run macro based on range value | Excel Discussion (Misc queries) | |||
Macro and a range of cells | Excel Discussion (Misc queries) | |||
Name a Range - Macro | Excel Worksheet Functions | |||
Use Range Name in Macro | Excel Worksheet Functions |