View Single Post
 
Old 01-30-2019, 10:19 PM
Guessed's Avatar
Guessed Guessed is offline Windows 10 Office 2016
Expert
 
Join Date: Mar 2010
Location: Canberra/Melbourne Australia
Posts: 4,176
Guessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant future
Default

The find/replace section would require "^77" instead of "Chr(77)"

Why are you placing these characters in there before replacing them in the find loop? Surely it would be better to place the[*] in the first place.
With Rng
.End = .Start + 2
.Text = "[*]" & vbTab
End With
__________________
Andrew Lockton
Chrysalis Design, Melbourne Australia
Reply With Quote