Share via

VBA Code Help for Circular Reference

Anonymous
2019-12-11T16:30:57+00:00

Good morning. Need some VBA help, if you don't mind. I'm needing a VBA code for a circular reference(?) and which works when there is data in either cell (remains blank if not). For example: if A1 has a word or content, then D1's content is that of A1, and if D1 has a word entered, then A1's content is that of D1 (otherwise the cells stay blank). I need to be able to type in either cell at any time without messing up or overriding the circular reference. Hope that makes sense. Thank you in advance.

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

Answer accepted by question author

HansV 462.6K Reputation points
2019-12-11T21:21:20+00:00

Remove the line

    If Target.Count > 1 Then Exit Sub

Was this answer helpful?

1 person found this answer helpful.
0 comments

5 additional answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2019-12-11T21:32:37+00:00

    Perfect! Thank you so much--for your time and help here.

    Was this answer helpful?

    0 comments