![]() |
#1
|
|||
|
|||
![]()
Hi!
I am totally novice in macros and VBA. I want to create a macro that will operate about 30 find/replace steps. The first find/replace I need to do consist in replacing a non printable (#0D) character which first occurrence is always located at the same position in the file. All other find/replace steps So I decided to create a macro using the "Record macro..." command. But almost no step I operate is recorded. For instance, after a succession of about 30 "find/replace" steps, I only get this in the macro: Sub Macro1() ' ' Macro1 Macro ' ' Selection.Copy End Sub Some times I only get the last Find/Replace step I tried several times, but only oner step is recorded in the macro (and not always the same step!!!) So, I have a few questions: 1. Is it normal that actions I did after I started recording the macro are not recorded? (for instance: the action of selecting a certain character at a certain location in the file, or all Replace actions I did...) 2. Is it possible to add a VBA step that will automatically select a character that is always located at the same place in the file? 3. How can I perform a Find/Replace step that finds all occurrences of #0D character and replaces them by something else? (i.e. paragraph break + "&&&" sequence) Many thanks in advance Last edited by Chibiberu; 03-30-2019 at 12:19 AM. |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
Modify recorded macro to run until end of document | peter961 | Word VBA | 1 | 09-04-2017 02:50 PM |
Embedded Video Not Playing in Recorded Presentation | bhadden1 | PowerPoint | 0 | 08-16-2017 03:07 PM |
Add previously recorded sound and synchronize with slide annimations | daniellouw | PowerPoint | 1 | 03-03-2017 11:14 AM |
Can I record more to add on to a recorded Macro? | Clueless in Seattle | Word VBA | 3 | 05-25-2015 01:21 AM |
Recorded audio (record slide show) won't play in older versions | Landy | PowerPoint | 0 | 03-03-2012 03:14 PM |