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 ...

You can use the “transform” property in CSS to rotate an element. In this post I’ll show you how using the “transform” property you can actually rotate an image at a given angle. ...

We often pass data between web pages as information in the form of URL parameters (or query strings). A URL can have single or multiple parameters. When redirecting to another page from your ...

In JavaScript, you can use window.location.href or simply window.location property to redirect to another page. This is a quick JavaScript tip for beginners. ...

You can insert a variety of objects like Excel workbook, PDF or Word document, images etc., in your email message using Outlook (any version). You can automate this process. I’ll show you how you can ...

In this post here, I’ll show you how to get the selected value in a SELECT dropdown list using plain old JavaScript. This is for the beginners. ...

In SQL Server, you can use PIVOT to convert multiple rows into columns to show a summarized result. I’ll show how using this method you can easily save the rows to columns converted data into a table ...

Let us assume, I have two ranges of values in my Excel worksheet. Each range has two columns each (region and sales). Now, both the ranges have some common regions. How do you find the matching record ...

In SQL Server, you can use the DATENAME() function to get the week day for a given date. I’ll show you how to use this function to get first and last day of a given month or date in SQL Server. ...

Let us assume, your web page has a DIV element and you want to auto-refresh its contents every few seconds. You can easily do this using jQuery or any other library. I’ll show how to auto-refresh a ...