cell("Address") problem

[foxguy]

name Address_R refers to $A$30

name Blank_R refers to $C$8



cell Address_R formula : =cell("Address",Blank_R)

cell Address_R display : $C$8



When I click a button with an assigned macro, before the macro even executes the first line,

cell Address_R display changes to "R8C3".



I've simplified the code

Please Login or Register  to view this content.

If I stop the code, go to Address_R, put my cursor in the formula bar and hit "Enter" (i.e. i don't change the contents of the cell) then the display changes back to "$C$8" and then macro continues fine.

[Leith Ross]

Hello foxguy,

Seems like you are triggering a worksheet event when the macro runs. You should post your workbook for review.

[foxguy]

I'm sorry, the workbook has proprietary code in it, and it would be too dificult to take it out.

How can I trigger a worksheet event without knowing it? I assigned a macro to a button. I put a breakpoint on the 1st line of the assigned macro. Before I clicked the button, the display was fine, but at the breakpoint the display had changed. Is there some event that occurs before the macro starts?

[broro183]

hi,

I don't have the answer but these questions might help find the problem...
- Have you pressed [Enter] to exit the cell before running the macro (I don't think it is even posible to not do this)?
- is application.enableevents equal to True or False?
- is Excel's Tools - Options - Calculation set to Manual or Auto?
- Does Excel's Tools - Options - General have the "R1C1 reference style" ticked?
- what happens if you change any of the above settings before attempting to run the macro?

For some (I'm sure I've read a more detailed article somewhere...) info on order of events have a look at Chip's page:
http://www.cpearson.com/excel/Events.aspx

Also to see what other code is running prior to your macro's breakpoint being reached, you can run the macro to the breakpoint & then press [ctrl + L] to bring up the "call stack". Based on your posts you should only see a "...button_Click" macro listed, if not, work backwards from what is listed there...

hth
Rob