VBA
Excel VBA to Jira? #YourComments
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
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.
My lost love for MS Excel and VBA (Transitioning from Kaplan to Alcatel-Lucent)
My second job with Kaplan Financial (earlier know as eMind) I worked mainly for Product Support and later as Project Coordinator where I was doing really interesting stuff.
How to change the background color of entire row in Excel using VBA code - Conditional
My friend Vinod gave me a problem to change the background color of entire row to Red and also to change the font to bold. It seems to be an easy task but there are two constraints.
1. He want to do this only for those lines which has font color of red.
Want to contact me?
Ravi Sagar
ravi at sparxsys dot com
Author of "Mastering JIRA 7" book. Loves #Jira and #Drupal. #Blogger, #ProblemSolver, #Atlassian #Consultant and #Technologist @ravisagar on twitter
Want my help? raise a support request for me.
Social and other Links
- RSS Feed
- Github
- @ravisagar on Twitter
- Ravi Sagar YouTube: Atlassian tools and Jira tutorials
- Ravi Sagar LBRY: Synced with Ravi Sagar YouTube
- Blackberry Boy YouTube: Linux, Emacs, Org Mode and tech tutorials
- Ravi Sagar Podcast
- @ravisagar.in on Instagram
- Ravi.pro: site published with Org Mode, general IT and tech stuff
- LinuxIndya.com: site published with Org Mode on Linux
- AutoGrid.info: site published with Org Mode on Excel VBA and Google Apps Script