Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 12-08-2014, 06:17 PM
htownpaper htownpaper is offline excel update superscript by 1 Windows 8 excel update superscript by 1 Office 2010 64bit
Novice
excel update superscript by 1
 
Join Date: Dec 2014
Posts: 5
htownpaper is on a distinguished road
Default

actually this is right:
Code:
Sub Demo()
Application.ScreenUpdating = False
With ActiveDocument.Range
  With .Find
    .ClearFormatting
    .Replacement.ClearFormatting
    .Text = "[0-9]@>"
    .Font.Superscript = True
    .Replacement.Text = ""
    .Format = True
    .Forward = True
    .Wrap = wdFindStop
    .MatchWildcards = True
    .Execute
  End With
  i = 0
  Do While .Find.Found
    .Text = CLng(i + 1)
    .Collapse wdCollapseEnd
    .Find.Execute
    i = i + 1
  Loop
End With
Application.ScreenUpdating = True
End Sub


Last edited by macropod; 12-08-2014 at 06:35 PM. Reason: Added code tags & formatting
Reply With Quote
Reply



Similar Threads
Thread Thread Starter Forum Replies Last Post
excel update superscript by 1 How to custom Date Picker CC format with Ordinal and superscript it! areriff Word VBA 5 08-21-2022 04:28 PM
Insert superscript into a textbox Deltaj Word VBA 3 11-30-2014 04:23 PM
excel update superscript by 1 Replace with superscript in Word 2013 docbike Word 4 04-07-2014 05:23 PM
Combining Files--Superscript problem lindajacques PowerPoint 0 01-06-2011 01:20 PM
excel update superscript by 1 Inserting Date, formatting to superscript and subscript louq Word 1 10-22-2009 09:29 AM

Other Forums: Access Forums

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