Excel Data Validation - Select Multiple Items - Need to Apply Macro to Multiple Rows

I added a data validation dropdown list to a spreadsheet, but need to figure out how to apply the macro to more than one column. I set the macro up following instructions I found in this thread:http://www.excelforum.com/excel-work...pick-list.html. An example of the code is attached (sheet titled "Same Cell"). In the sample code I used on my own worksheet, I need to change the bolded line of code to allow me to apply the macro to 2 columns (currently it is applied only to column 3, per the code). Any help would be appreciated, thanks!

Please Login or Register  to view this content.

Hum..... what is your question again? And are you using Excel 2011 "MAC" version?