On Jun 30, 9:06 am, Mike wrote:
one thing looks like your missing
Dim Narrative As Long


Thanks, "Narrative" was actually that Downcounter variable until a few
minutes before posting that code... :)

Any suggestions, other than a loop through the Cells collection (which
would be really really slow) on how I could do what I'm trying to do?

When I originally wrote this program I deliberately chose to base it
on a replace all method rather than a loop because its much faster,
and this is a macro which I use quite a lot.

Travis