Ok, so I inserted a macro that specifically formatted my printout of a range
of cells. I decided to change that formatting and deleted some lines of
code. HOWEVER, when I run the macro, it prints out the range of cells the
original way the code was written.

I can see no modules, no user forms, or other command buttons other than the
one I am using. Am I missing something here?

Clark wrote:
Ok, so I inserted a macro that specifically formatted my printout of a range
of cells. I decided to change that formatting and deleted some lines of
code. HOWEVER, when I run the macro, it prints out the range of cells the
original way the code was written.

I can see no modules, no user forms, or other command buttons other than the
one I am using. Am I missing something here?

Maybe you have 2 copies of the macro in different spreadsheets? Maybe
one in the sheet where you use it and one in PERSONAL.XLS?

Hope this helps in your world.

hi,
post your code. before and after.

FSt1

"Clark" wrote:

Ok, so I inserted a macro that specifically formatted my printout of a range
of cells. I decided to change that formatting and deleted some lines of
code. HOWEVER, when I run the macro, it prints out the range of cells the
original way the code was written.

I can see no modules, no user forms, or other command buttons other than the
one I am using. Am I missing something here?

Ranges in Macros do not adjust when you delete rows like worksheet formulas
do.

--
Regards,
Tom Ogilvy


"Clark" wrote in message
...
Ok, so I inserted a macro that specifically formatted my printout of a
range
of cells. I decided to change that formatting and deleted some lines of
code. HOWEVER, when I run the macro, it prints out the range of cells the
original way the code was written.

I can see no modules, no user forms, or other command buttons other than
the
one I am using. Am I missing something here?