Having the user specify a column when running a macro

**garncor** · 08-21-2008, 02:18 PM

Hi All,

I have a very simple macro that I use to highlight duplicates in a column...

Please Login or Register  to view this content.

In this example, the macro is applied to column A. Is there some way that I could have a user be prompted for which column they wish to check for duplicates when they run the macro? Thanks in advance.

-Corey

**protonLeah** · 08-21-2008, 03:30 PM

Please Login or Register  to view this content.

**garncor** · 08-21-2008, 03:42 PM

coooool....but how would i use it in conjunction with the macro that scans for duplicates within the selected column?

sorry, i'm a bit of a newbie

thanks.

-corey

**SOS** · 08-21-2008, 04:42 PM

Hi corey

Try this:

Please Login or Register  to view this content.

Of course you can change the name of the variable to anything you want

**garncor** · 08-25-2008, 01:15 PM

worked like a CHARM

thanks very much, Seamus

Having the user specify a column when running a macro

LinkBack

Thread Tools

Rate This Thread

Display

Having the user specify a column when running a macro

Thread Information

Users Browsing this Thread

Similar Threads

Macro to Search, Copy/Paste onto New Sheet

Issues pasting in column B and making 2nd macro available

Error Saving after running Macro

How to get last name from A Column to copy to B column

Macro to define name range based on user input

Bookmarks

Bookmarks

Posting Permissions