Help please, my Macro just shocked me with circular references!

[andretch]

Hi all,

i'm writing a macro to handle some math.

basically, i need the to use some user input to compute the temperature distribution within a certain plane.

thus, each cell's value will be the average of the neighbouring 4 cells.

everything was running well until excel decided it would be funny to crash and give me a circular reference error prompt. meaning to say the codes were all working and it suddenly just crashed.

is there a way i can remove this error?

[coreytroy]

Please Login or Register  to view this content.

will ignore the error,if place before a error trigger.
But, that does it fit the error, but simply carrys on with the vba.

[andretch]

Untitled.jpg

this is what i get on my spreadsheet after running the macro.. before this issue everything was running fine.

each cell with value 0.000 has the formula "Average(N,S,E,W)"

note the circular references just below the sheets tab.