I'd like to have the user select cells in a worksheet they want to work with, (non congruent cells), then click an icon in the ribbon that does blah blah blah to those cell.
How do I pass just the cells they selected as a range into my macro?
Find centralized, trusted content and collaborate around the technologies you use most.
Learn more about CollectivesStack Internal
Knowledge at work
Bring the best of human thought and AI automation together at your work.
Explore Stack InternalI'd like to have the user select cells in a worksheet they want to work with, (non congruent cells), then click an icon in the ribbon that does blah blah blah to those cell.
How do I pass just the cells they selected as a range into my macro?
SelectionFor Each cell In Selection