Using vb to Correctly format sentances

I am looking at the formula/macro and want a little help with how I could adjust it to add in a Range that I have as a defined name. In my case I defined the range as "comments".

I am drawing the basis of the formula from this thread http://www.excelforum.com/excel-gene...ence-case.html
Which uses this as the solution to Correctly formatting sentences in cells. I want to use it with defined ranges.

Please Login or Register  to view this content.

Tried changing it to because my activesheet is called ServiceDeliveryTemplate and the defined name is Comments but I am not selecting the range correctly.

Please Login or Register  to view this content.

You actually have to tell excel what the name of the worksheet is and what the range is

Please Login or Register  to view this content.