Macro to auto-populate word template with bookmarks

Hi all,

I have a spreadsheet that auto-populates certain data into a word template using bookmarks.

The issue I have is the data selection always changes dependant on the row number, the range column will always be the same, however the row number will change.

Could someone please help me out with how to set a range to always be the same column, but the row number will change dependant on the cursor selection made by the user?

Currently my code is as follows, which works as I would like it to, however currently the ranges are fixed as I couldn't figure out how to set the ranges as I would like to;

Please Login or Register  to view this content.

All your help is very much appreciated, I have attached the file for your reference.

Many thanks all

Dell