Hi AB33,
Thanks for your response.
As I am new to VBA I don't really understand what you mean with your comment about tags, but I have added a snapshot of my code in a picture. I don't now how to create these tekst boxes with formatted code as you see in other threads. Sorry.
The code LINE where is determine the target range is below:
Set dRng = dLo.HeaderRowRange.Columns(1).Offset(dLo.ListRows.Count + 1, 0)
Hope this helps clarify
Regards,
Purpose
Code sample.png
Bookmarks