MM0004 - 23/12/19 - Working With Multiple Files In VBA 2

In this stream, we combine together multiple techniques to dynamically define a data range in another file, which should means our macros will work for some time to come.  The approach is very closely based on what Chris uses in real-world projects - enjoy!

Topics

  •  | Description Of A Typical Task
  •  | Discussion: Any Approach Has Pros And Cons
  •  | Range(Range,Range) - Concept
  •  | .End(xldown)
  •  | .Row Property
  •  | .End(xldown) - Weakness And Alternative
  •  | .End(xlup)
  •  | .Rows.Count
  •  | Find And Replace
  •  | LEFT
1 Lesson