While working on worksheets using a macro, you may sometimes need to know if a particular worksheet exists in a workbook or not. Especially, when the worksheets have random names. You either ...
An alphanumeric value in an Excel cell may look like this “70 kg” (a number and two alphabets). Now, let us assume, I have two cells with values 70 kg and Rs. 50. How do I calculate these alphanumeric ...
There are many ways you can run or execute a macro like, pressing the F5 key in VBA or simply clicking the run button. Or, you can insert a button (an ActiveX Control) on your Excel worksheet, click ...
Let us assume, I have sales data in my Excel worksheet for two or more consecutive years (for certain products), which I collect from different regions. I want to know the percent change in sales fig ...
Let us assume I have a UserForm in my Excel worksheet, which has few controls (or elements like textbox, label, checkbox etc.). How do I check if the control is a checkbox using a VBA macro? ...
Let us assume I have a word file with few paragraphs in it. I want to copy content as it is from the doc file and write it in my Excel worksheet, each word in a cell, go to the next line or row and ...
In my previous article on Excel automation using VBA, I have explained how to fill a web form and save the data, from Excel using VBA. The data that I have used in that example were hardcoded ...
Web scraping is a process where an application extracts data or content from a web page. You can do this from an Excel worksheet using VBA. I have shared an article here before where I have explained ...
In Excel, there is an in-built feature called the Subtotal (under the “Data” tab) which when used can automatically insert subtotals and grand total for a selected range of data. However, if you are ...
In Excel, you can use the EXACT() function to compare two text strings, to check if the texts are similar or not. ...