Cross reference letter case: Beginning of sentence and middle of sentence

Afternoon,

I found this code to change all the cross references to lower case, e.g. "Figure 3 shows ....." becomes "figure 3 shows .....", all cross references change to lower case. I want to add a condition that when the cross reference is in the beginning of a sentence, the case must remain upper case, e.g. ".... after ten years. Figure 3 shows ....." and not ".... after ten years. figure 3 shows ....." but in the middle of a sentence it should be ".... as seen in figure 3..." and not "...as seen in Figure 3..."

This is the code:

```

Please Login or Register  to view this content.

```

Please assist.

Regards
Caswell1000

Code Tags Added

Hi and welcome
Your post does not comply with Rule 2 of our Forum RULES. Use code tags around code.

Posting code between [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.

Highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found at http://www.excelforum.com/forum-rule...rum-rules.html



(I have added them for you today. Please take a few minutes to read all Forum Rules and comply in the future.)

Oh, and by the way, don't hesitate to show some courtesy like, " Hello" or " Thanks". They are not considered coarse language, and are, indeed, a good introduction to speedy answers

Thank you, apologies for the awful behaviour.

Try:

Please Login or Register  to view this content.