Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 01-16-2014, 11:12 AM
Jennifer Murphy's Avatar
Jennifer Murphy Jennifer Murphy is offline Macro to reverse a test string Windows XP Macro to reverse a test string Office 2007
Competent Performer
Macro to reverse a test string
 
Join Date: Aug 2011
Location: Silicon Valley
Posts: 234
Jennifer Murphy is on a distinguished road
Default

Thank you, that works perfectly.

I wasn't sure if I needed the variable oString.



Is there some reason that you changed my variable name from oRange to oRng?

I just noticed another little problem. The entire reversed string gets assigned the formatting of the first character in the original string.

If my original string is "This is some text", the reversed string becomes "txet emos si sihT". Is there a way to preserve the formatting so that the result is "txet emos si sihT"?
Reply With Quote
Reply



Similar Threads
Thread Thread Starter Forum Replies Last Post
Macro to reverse a test string Way to search for a string in text file, pull out everything until another string? omahadivision Excel Programming 12 11-23-2013 12:10 PM
Macro to reverse a test string Macro to create new word doc and save the file using String found in the document VBNation Word VBA 2 02-08-2013 07:14 AM
Macro to reverse a test string Call Macro from Input Box String Paulsh Word VBA 1 11-01-2011 03:15 AM
Macro to reverse a test string Macro VBA "Save as" with bookmarks in file name string Dom37 Word VBA 2 10-31-2011 03:28 AM
Macro to reverse a test string Macro or Function to know wether a string is included in a text Eduardo Word VBA 5 06-15-2009 01:55 AM

Other Forums: Access Forums

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


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