Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 05-27-2015, 12:48 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 Macro to add title in header is missing text once macro is run

Hi experts,


I have created a macro to format a spreadsheet, including adding a title in the header. After to macro is run, the text 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 attachments. Why might this be happening and how would I correct this? Thanks in advance
Attached Images
File Type: png Capture1.PNG (35.0 KB, 12 views)
File Type: png Capture.PNG (3.8 KB, 12 views)
Reply With Quote
  #2  
Old 05-27-2015, 11:50 PM
Pecoflyer's Avatar
Pecoflyer Pecoflyer 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
Expert
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,779
Pecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant future
Default

Please post the sheet containing the macro. Thanks
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post
Reply With Quote
Reply



Similar Threads
Thread Thread Starter Forum Replies Last Post
Macro to add title in header is missing text once macro is run shawnee24 Word VBA 3 05-27-2015 12:35 PM
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

Other Forums: Access Forums

All times are GMT -7. The time now is 11:32 PM.


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