Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
copy 1 document and when original updated copy is also | Excel Discussion (Misc queries) | |||
I copy a formula and the results copy from the original cell | Excel Discussion (Misc queries) | |||
Copy and Paste Date - weird behavior | Excel Discussion (Misc queries) | |||
Major Goof, I deleted data HELP | Excel Worksheet Functions | |||
Weird macro mistakes or goof ups | Excel Programming |