| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Help with Variable Ranges! | Excel Discussion (Misc queries) | |||
| Variable Ranges | Excel Worksheet Functions | |||
| variable reference ranges | Excel Discussion (Misc queries) | |||
| Variable ranges | Excel Worksheet Functions | |||
| Sum Variable Ranges | Excel Worksheet Functions | |||
Threaded Mode
