Function is changing surrounding cells.

[ShayA]

Just learning. There is something fundamental I am misunderstanding here. Trying to search down the active column for explicitly entered "arriving" and "leaving" cells and fill in the blanks. This is a simplified special case for the top cells in a column. The cells below the top look up one row and assign a value based on that "previous" row's entry. The whole thing works, but calling the function from one cell changes other cells with that function.

Please Login or Register  to view this content.

Thank you.

[Bob Phillips]

I think that you need to show the code that calls that function.

[ShayA]

I think that you need to show the code that calls that function.

Here it is:

Please Login or Register  to view this content.

Again, I may have some fundamental understanding of how this is supposed to work.

[ShayA]

Your problem is this line:
You should replace Activecell with Application.Caller and make the function volatile. I'm not sure what the point of the argument you pass is?

Thank you!

This is only a special case for the top row. The other rows use the argument. Skipping the argument and using Offset(0,-1) worked, but the sells didn't automatically update. I'm still learning.