Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #3  
Old 08-18-2021, 09:16 PM
Peterson Peterson is offline Trouble converting a sub to function, incl. passing argument and nixing Selection Windows 10 Trouble converting a sub to function, incl. passing argument and nixing Selection Office 2019
Competent Performer
Trouble converting a sub to function, incl. passing argument and nixing Selection
 
Join Date: Jan 2017
Posts: 143
Peterson is on a distinguished road
Default

Thanks for your help and explanation, Andrew. I'm afraid I've failed to describe just what I'm trying to achieve.

The overall objective is to:
  1. Extract capitalized text from the beginning of a document
  2. Pass the text to a function that converts it to camel case
  3. Pass the camel-case text back and do other stuff
In my code yesterday, I included the following line to set the range:
Code:
Set rngTitle = ActiveDocument.Words(1)
I actually don't want the first word in the document to be the range. I only used this code because I can't otherwise figure out how to convert the all-cap'd text to a range, which I assume is necessary in order to run the text through the MakeTitleCase code, as there's no user-selected text, so Selection can't be used. Among other attempts, I tried the following, which doesn't work:
Code:
Set rngTitle.Text = "SECTION 00 00 00, ETC."
I think I'm misunderstanding the range concept; that is, perhaps a range can apply only to some portion of a document?? I'm stuck on it because I don't know how else to get around the Selection issue. Or maybe I need to do this differently, by parsing the entire string, evaluating each word on its own, then re-assembling?? In other words, Allen's macro really only works for user-selected text and trying to convert it to work on a range won't work, in this case (sorry, bad pun).

Thanks again.
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
Having trouble creating a multiple selection drop down list, even after checking other threads sbelinski Word VBA 1 12-14-2020 03:33 PM
Trouble converting a sub to function, incl. passing argument and nixing Selection Help wanted passing data to Form kirkm Word VBA 4 09-19-2016 07:03 PM
Trouble converting a sub to function, incl. passing argument and nixing Selection trouble with pdf doc after converting to word.. tom356 Word 3 09-11-2016 08:23 AM
Trouble converting a sub to function, incl. passing argument and nixing Selection passing variable from one sub to another gbrew584 Excel Programming 10 03-21-2016 12:06 AM
Trouble converting a sub to function, incl. passing argument and nixing Selection userform help (having trouble passing info from form to macro) cyraxote Word VBA 16 09-08-2015 04:16 AM

Other Forums: Access Forums

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