Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 07-22-2022, 06:18 AM
TangoAlphaZulu TangoAlphaZulu is offline Requesting Assistance Understanding a line of Code Mac OS X Requesting Assistance Understanding a line of Code Office 2016 for Mac
Novice
Requesting Assistance Understanding a line of Code
 
Join Date: Jul 2022
Posts: 3
TangoAlphaZulu is on a distinguished road
Default Requesting Assistance Understanding a line of Code


I have been recording some macros, and this is one line from the macro I got when recording the page setup dialog. I would really like some help breaking down the syntax of the line so I can edit it and insert it in other places.

.CenterHeader = _
"&""Times New Roman Bold Italic,Bold Italic""&16 &K0000002023 MS 150 Roster" & Chr(10) & "&T&D"

1. Why did excel break the line and put the underscore in? I have pasted the line in just as it appears in the App.
2. The Text reads on the page as "2023 MS 150 Roster", with the date and time underneath.

Thanks for helping out,
Jeff
Reply With Quote
Reply



Similar Threads
Thread Thread Starter Forum Replies Last Post
Outlook keeps requesting my password jparnold Outlook 1 10-05-2018 12:21 AM
Requesting Assistance Understanding a line of Code Assistance with VBA Code to identify and highlight dates in a word doc shaunlthomas Word VBA 1 08-13-2015 05:25 PM
Require assistance in writing code to login to webmail account. saurabhlotankar Excel Programming 4 05-21-2015 10:47 AM
need help understanding mailmerge code lhuffst Mail Merge 1 02-13-2013 05:19 PM
Pop-up requesting me to download a file when Gillonline Outlook 0 04-18-2012 01:33 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 01:18 AM.


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