loves_automation
New Member
- Joined
- Feb 21, 2002
- Messages
- 7
I have a selection.merge command in my macro on a set of cells with the same value. This causes Excel to prompt me "Keep only value in top cell?" to which I have to click "Yes". This totally defeats the purpose of my macro, which is to eliminate user intervention. There must be something I can add to my macro to merge without prompting the user?