Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 08-11-2011, 02:33 AM
macropod's Avatar
macropod macropod is offline automatic text formatting(justify) Windows 7 64bit automatic text formatting(justify) 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

Links to macro installation & usage instructions are below the code in post #6
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #2  
Old 08-13-2011, 12:14 PM
rtcole rtcole is offline automatic text formatting(justify) Windows Vista automatic text formatting(justify) Office 2007
Novice
 
Join Date: Aug 2011
Posts: 3
rtcole is on a distinguished road
Question Thanks but still a problem

Thanks so much for the help. I have followed the copy and paste procedure, pasting the whole macro from the window above, and tried the macro. I get "Compile Error: Expected End Stub" and when I click help, I get:

"An End procedure statement must match the procedure in which it occurs. This error has the following cause and solution:
  • You used End Function or End Property to end a Sub procedure.Use End Sub for this type of procedure"
It seems that the macro does have "End Sub" so what do I need to do?
Reply With Quote
  #3  
Old 08-13-2011, 06:56 PM
macropod's Avatar
macropod macropod is offline automatic text formatting(justify) Windows 7 64bit automatic text formatting(justify) 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

Quote:
Originally Posted by rtcole View Post
Thanks so much for the help. I have followed the copy and paste procedure, pasting the whole macro from the window above, and tried the macro. I get "Compile Error: Expected End Stub" and when I click help, I get:

"An End procedure statement must match the procedure in which it occurs. This error has the following cause and solution:
  • You used End Function or End Property to end a Sub procedure.Use End Sub for this type of procedure"
It seems that the macro does have "End Sub" so what do I need to do?
Are you sure you copied & pasted the whole macro - it certainly inlcudes the 'End Sub' statement! Also, no-one else has reported this error, which suggests the problem is at your end.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Automatic Formatting for whole row Bacchanal Promotions Excel 2 03-19-2011 05:12 AM
automatic text formatting(justify) Office 2007 Mail Merge Issue - automatic formatting and revisions balloons sharpie21 Office 1 10-10-2010 03:56 AM
Automatic insertion of blank pages or alternate text Diopippo Word 0 07-06-2010 12:13 AM
automatic text formatting(justify) problem with automatic formatting on quotation marks Bobosmite Word 3 05-27-2010 07:06 PM
Templates: automatic text generation from Rich Text content control Chickenmunga Word 0 10-01-2008 11:16 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 12:19 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft