By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,961 Members | 1,332 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,961 IT Pros & Developers. It's quick & easy.

Merging in excel vbokay

Expert 100+
P: 295
I need to know how to always say yes to the prompt since it always prompts me for yes to merge

Expand|Select|Wrap|Line Numbers
  1. Cells.Range(range_str1).Merge
Apr 25 '07 #1
Share this Question
Share on Google+
1 Reply

Expert 5K+
P: 8,434
Try this...
Expand|Select|Wrap|Line Numbers
  1. Application.DisplayAlerts = False
  2. Cells.Range(range_str1).Merge
  3. Application.DisplayAlerts = True
I haven't tried it, but it might work. According to the help, this will cause Excel to choose the default response when it would normally prompt the user.
Apr 25 '07 #2

Post your reply

Sign in to post your reply or Sign up for a free account.