Hi all,
I have a several files that are all created off the one template, but vary in the number of rows. In one column in each file I have joined up the four preceding columns to consolidate the information. In this column I have used char(10) to seperate the formula into four paragraphs. I then copy and paste values the column into the next adjacent so I can manually highlight paragraphs two and three. Is there a macro I can run that will complete the highlighting part that I can use for each file (taking into account the varying number of rows on each)?
Cheers, Avendi