Removing a macro
 

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?

Removing a macro
 

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.

Removing a macro
 

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?

Removing a macro
 

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?