#46
|
||||
|
||||
See post #42!!!
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
#47
|
|||
|
|||
Hi Paul
I can understand your situation. I am close to complete this task except this fix. I know this is also another new instance which i found inconsistency in this task. If you provide the suggestion for this will helpful for me.... The only think we have to do "PV: RR" to insert after without deleting the exist texts in the cell to "PV: [point value]" Thanks ganesang |
#48
|
||||
|
||||
As I said, you can do it via Find/Replace. You could even record a macro for that!
Nevertheless, insert: Code:
With .Range.Find .ClearFormatting .Replacement.ClearFormatting .MatchWildcards = True .Forward = True .Format = False .Wrap = wdFindContinue .Text = "(PV: )RR([0-9])" .Replacement.Text = "\1\2" .Execute wdReplaceAll .Text = "(PV:)RR([0-9])" .Replacement.Text = "\1 \2" .Execute wdReplaceAll End With
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
#49
|
|||
|
|||
Thanks Much Paul!!! for you big help on this
|
#50
|
|||
|
|||
Hi Paul
I just wanted to check that, Is there any possible to call the other function called as like "Sub QID(ByVal Control As IRibbonControl)" in this macro? I am trying to call the above macro but having the error. |
#51
|
|||
|
|||
Thanks Paul
I got the answer on this question!!!! thanks much again for your big help |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Need macro to fill data from different sheets based on selected item from drop down | skorasika | Excel Programming | 1 | 03-13-2015 11:25 AM |
Newbie to excel for starters, needing to transfer info from sheet2 to universe sheet. | rogcar75 | Excel | 0 | 08-12-2014 07:21 AM |
Color-fill a range of cells, based on text in a different sheet. Possible? | unittwentyfive | Excel | 2 | 06-01-2014 06:48 AM |
link conditional info in word based on excel list | stijnvanhoof | Mail Merge | 1 | 11-13-2012 01:55 PM |
Open Word w Excel & fill Word textboxes w info from Excel fields runtime error 4248 | Joe Patrick | Word VBA | 2 | 01-30-2012 07:23 AM |