Excel macro

[msz]

I have an excel file which over the years use some
converted lotus 123 macros. I upgraded from Excel 97 SR-2
to WindowsXP Excel 2002. Now one macro I use will not
convert to excel 2002. This uses the Lotus 123 MENUBRANCH
function. The macro allows me to select froma variety of
ranges and then copy/paste that range into another range.
Anyone know how To convert this function or how to work
around so I can easily choose a range from a drop down
window?

 

[Don Guillett]

Look at your transition option in options or change to data validation
Data>validation>list