I would be surprised if many will wade through such a long routine trying to
solve you problem.
Explain what the source data is like and why you code does achieve the
result.

NickHK

"edluver" wrote in message
...
This is a copy of the macro that i have written to automate some
formatting
needed to work a computer generated report. The problem that i am running
into is that the program is currently set up to run line by line of the
report, but there are some accounts that take up several lines of the
report.
I need a piece of code that will work one account at a time. Can anyone
help?

[code]
Sub TestMacro()
'
'TestMacro Macro
'Macro written by Edward Lane
'February 20, 2007
'

'Show's "Now Formatting" message
MsgBox "Now Formatting", vbInformation, " "
'Setting variables
Dim HotList As Range, OCList As Range
'The

------ CUT -----------