Since nobody has replied yet to sth I expected to be easy, I will reformulate my demand:
Let's say I have a sheet with data and titles in the first row. I would like to select the data area in order to copy it on another sheet. For this I expect a code as Union(range1,range2) or Intersect(range1,range2) but it would make the difference (Diff).
In my case:
set MyRange= Diff(cells(1,1).currentregion, rows(1))
Is there in VBA such a function as the Diff I defined above?
If not I know I can use:
set MyRange= Intersect(cells(1,1).currentregion, range(cells(1,1),cells(10000,1000))
It will give the same result but I think the code is less 'clean'.
br,
Pierre