Thread: Help with Case and Select case
View Single Post
 
Old 10-01-2015, 10:17 PM
macropod's Avatar
macropod macropod is offline Windows 7 64bit Office 2010 32bit
Administrator
  
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,467
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default
To put it politely, your code is a dog's breakfast. You have:
• Application.ScreenUpdating = False used twice
• a bookmark apparently named CCBmk but defined as a Boolean
• bits of Case tests that are not part of a Select Case structure,
and so on.

I could mess around correcting all that, but I can't even tell from that mess what the code is supposed to do. Perhaps you'd care to explain?
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote