When copying a table from Excel to Word - omit row from a table if cell in first column is empty

[Habo]

Have seen some similar questions but have not been able to solve my particular problem.

I have a given (non-changing) range, lets say N2:T9. Based on user input, one or more of the cells N3 to N8 might be "empty" (i.e. a formula returns no text).

My goal is to copy this range N2:T9 as a table into word, but omit the lines where column A is empty. Note that the range is not sorted, so the empty cells can be one or more, scattered between A1 and A7.

As of now, I define the whole range as a table and it is pasted into my word template. But it would be nice to exclude the empty rows from the range before pasting.

PS: Just started with VBA

 

[Habo]

Edit;

"Note that the range is not sorted. I.e. the empty cells can be one or more, scattered between A1 and A9. A1 and A9 will always have a text and should thus always be included in the range"