I need to use a macro to perform a function (clean) to an entire row.
normally i would record a macro, and then go from there. in this case, i
would use another row as a buffer then paste special. that seems like a lot
of unnecesary code.

there has to be a more eloquent way to do this. using memory spaces, i'd
assume. just not sure how.

thanks,
mark