Thread: variable ranges
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
gramps gramps is offline
external usenet poster
 
Posts: 46
Default 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