Dim rng As RangeWhere:
Dim rngA As Range
Dim rngB As Range
Set rngA = ActiveSheet.Range("A3:V3")
Set rngB = ActiveSheet.AutoFilter.Range
Set rng = Application.Union(rngA, rngB)
- Column size for rngA = rngB
- A3:V3 is the header of the autofilter
Note:
- Normally the function is used to insert the range in email as a body
No comments:
Post a Comment