Delete Rows with VBA

Delete Rows with VBA

Written by: Thomas Szigeti Hey all! Today we will discuss a VBA technique which we have to use every now and again. This is when we have to delete row or rows in a workbook with VBA code. Deleting rows in VBA is a bit tricky because if you start looping through the...
How to add an Excel VBA code to my workbook?

How to add an Excel VBA code to my workbook?

I found an Excel VBA Code on the internet. How do I add it to my Excel file? O.K. So first I want to share a bit of information on What is VBA code.For the actual steps please scroll down.What is VBA Code in excel?VBA is stands for Visual Basic for Applications. It is...
How to add autosave with a piece of VBA code to any excel workbook?

How to add autosave with a piece of VBA code to any excel workbook?

Have you ever wished that you could add some kind of autosave to your workbook that you control?While the built in Autosave in MS Excel works most of the time,there are instances where you want to secure your work yourself. How can we do this? We will need to add two...
Convert Conditional formatting

Convert Conditional formatting

Have you ever had to convert conditional formatting on a sheet? It happened to me in more than one occasion.Usually when I had a nice sheet with all the bells and whistles, all conditional formatting working and colorful, then I had to send a value only version of...