VBA

Excel VBA to Jira? #YourComments

Submitted by ravisagar on Sat, 02/06/2021 - 13:22

Do you want to use Excel along with Jira but wondering how to connect them together?

#YourComments #ExcelVBA #RESTAPI

Learn Jira REST API, here is my free course.

Excel VBA macro to convert the case of the first letter in a sentence

Submitted by ravisagar on Mon, 11/13/2017 - 17:22

Let us say you have a some sentences in your excel sheet in one or two cells. Now if you are very particular about punctuation like me then you may want to change the case of all the words starting in a sentence. Let us say you have some sentences like below in various cells.

Ravi Sagar Newsletter

Honestly I hardly send out mails but I guess there is no harm in at least having a newsletter. I will only send newsletter when I have something important to share or an update. People are busy and no one has time to read emails these days. If you really like my content then I guess you will remember my site and come back for more.

Want to contact me?