how about

if ucase(range("b6"))="A" then call Run_a


--
Don Guillett
SalesAid Software

"scottwilsonx " wrote in
message ...
Hello again everyone.

I would like some help with writing a code that will do the following:

I have 4 seperate VBA codes that sort my data in different ways. What I
want to do is write a separate code that will run a different macro
depending on what value is selected in cell B6.
For example, if b6 =a then it will run macro Run_a, etc

Thanks
Scott.


---
Message posted from http://www.ExcelForum.com/