Microsoft Office Forums

Go Back   Microsoft Office Forums > >
Reload this Page Macro to add title in header is missing text once macro is run
Register FAQ

Reply
 
Thread Tools Display Modes
  #1  
Old 05-26-2015, 07:47 AM
shawnee24 shawnee24 is offline Macro to add title in header is missing text once macro is run Windows 7 64bit Macro to add title in header is missing text once macro is run Office 2010 64bit
Novice
Macro to add title in header is missing text once macro is run 		 
Join Date: Mar 2015
Posts: 6
shawnee24 is on a distinguished road
Default Macro to add title in header is missing text once macro is run
Hi, I have created a macro to format a spreadsheet, including adding a title in the header. One of the fields in the header is incomplete, even though in VBA it appears as it should. Specifically, the word "REPORT" finishes as "RE" when the macro is run. Please see my attachment. Why might this be happening and how would I correct this? Thanks in advance!
Attached Images
File Type: png Capture.PNG (18.6 KB, 16 views)
Reply With Quote
  #2  
Old 05-27-2015, 01:36 AM
gmayor's Avatar
gmayor gmayor is offline Macro to add title in header is missing text once macro is run Windows 7 64bit Macro to add title in header is missing text once macro is run Office 2010 32bit
Expert
  
Join Date: Aug 2014
Posts: 4,103
gmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud of
Default
The bit of code in the illustration does not result in the curtailment of the header. Without knowing what else is in the macro it is impossible to suggest what else might cause the problem.
__________________
Graham Mayor - MS MVP (Word) (2002-2019)
Visit my web site for more programming tips and ready made processes www.gmayor.com
Reply With Quote
  #3  
Old 05-27-2015, 11:49 AM
fumei fumei is offline Macro to add title in header is missing text once macro is run Windows 7 64bit Macro to add title in header is missing text once macro is run Office XP
Expert
  
Join Date: Jan 2013
Posts: 440
fumei is on a distinguished road
Default
You may also get a quicker answer if you post in the Excel forum. This is the Word forum.
Reply With Quote
  #4  
Old 05-27-2015, 12:35 PM
shawnee24 shawnee24 is offline Macro to add title in header is missing text once macro is run Windows 7 64bit Macro to add title in header is missing text once macro is run Office 2010 64bit
Novice
Macro to add title in header is missing text once macro is run 		 
Join Date: Mar 2015
Posts: 6
shawnee24 is on a distinguished road
Default
Oops thank you - obviously wasn't thinking....
Reply With Quote
Reply

Tags
header, macro, text missing

« Previous Thread | Next Thread »


Similar Threads
Thread Thread Starter Forum Replies Last Post
Macro to add title in header is missing text once macro is run Allow User to Input Title When Running Attachment Macro rdross51 Word VBA 11 02-27-2015 05:52 AM
Macro to add title in header is missing text once macro is run Macro button missing namedujour Word VBA 0 08-25-2014 11:21 AM
Add Month Name to Title via macro bremen22 PowerPoint 5 08-29-2013 05:28 AM
Header automatically displays title of next section Dr Wu Word 1 04-11-2013 02:59 AM
Macro to add title in header is missing text once macro is run Macro to get first letter of a page in the header faramir Word VBA 4 11-16-2011 05:43 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 12:50 PM.

Contact Us - Privacy Statement - Top

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