Weird macro mistakes or goof ups - copy of original post
 

Hi Gord,
sorry for the re post but i had not had time to check this
since you posted your message and figured it'd be lost and
not checked up on now. What part of the code or how much
of it should i post?

A.
Tks

-----Original Message-----
Andre

Post your code.

Gord Dibben Excel MVP

On Wed, 7 Jul 2004 09:44:41 -0700, "André"
wrote:

I've created 2 macro's for the same workbook to do 2
different things that seem to work except for some
things
i can't explain. The first macro is set to rename a
sheet
(lets call it sheet z) and some cells on sheet z, it
also
changes 5 cells on the fist sheet (lets call it sheet a)
into IF functions that refer to cells on sheet z. Now
what happens is that the 4 cells ajacent to 4 of the 5
cells on sheet a (as well as some other random cells
that
arn't ajacent) have #Ref in the cells. When recording
the
macro I did not make any changes to the cells that have
#Ref and so I have no clue why it's doing that.
The 2nd macro is used on sheets c to G to remove colums
and rename the cells b2 to e2. Now it does that just
fine
however it removes the text I have in cells A1 and A2.
(A1 streches across 6 columns if that makes a difference)

Anyone have any idea why this is happening or how I can
fix it?

A.
/perplexed

.