Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 12-03-2020, 01:05 PM
VBorNotVB VBorNotVB is offline Declare Constant for Chr(14) Mac OS X Declare Constant for Chr(14) Office 2016 for Mac
Novice
Declare Constant for Chr(14)
 
Join Date: Oct 2018
Location: Southern California
Posts: 25
VBorNotVB is on a distinguished road
Default Declare Constant for Chr(14)


Word has built-in constants such as vbCr = Chr(13) and vbFormFeed = Chr(12).
How can I declare my own constant vbColumnBreak = Chr(14)?

Word VBA compiler objects to "Chr" in the following declaration:
public const vbColumnBreak as string = Chr(14)
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
Declare wBk as workbook. Set wBk = workbooks("NewBook.xls") gives error: Subscript out of range. Syed Shabbir Excel Programming 1 09-27-2020 09:35 AM
constant request for password for Outlook.com workingmom Outlook 0 10-20-2016 12:37 PM
Constant Request for Server Passwords danpbphoto Outlook 1 01-12-2015 07:28 AM
Declare Constant for Chr(14) Keep cell in formula constant jprt68 Excel 1 06-26-2012 08:31 AM
Declare Constant for Chr(14) Keeping the top row constant in Excel MSmand Excel 2 07-13-2011 01:14 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 01:45 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