variable ranges
Hi
I have Change event macro that sorts a table in G3:O6 when a value in F3:F6
is changed. What I need to happen is that if the range of the entered data is
F13:F18 the table sorted changes to G13:O16. I have been trying to vary the
values in the €˜If Not Intersect(Target, Range("F13:F18")) Then statemnt but
without success. Any help would be appreciated.
Al
|