I'm currently going through a book on VBA programming that gives the following example:
I'd like to expand the functionality to include a Case where multiple areas are selected and the return string is "Multi" but I cannot for the life of me figure out how to do that. It seems like I should just be able to add an If statement that covers whether or not Selection.Areas.Count > 1 but I'm getting nowhere with that. I get the idea I need to incorporate ParamArray in the function arguments but I don't see why because I don't need to loop through an array to count any values when Selection.Areas.Count already has the correct count. I'm grateful for any help with this!
Bookmarks