Jump To: Unprotecting and Protecting the Worksheets Unprotecting and Protecting Workbooks Unprotecting and Protecting the Worksheets: As a VBA programmer you will often have protected sheets where you would like your program to be able to modify but still remain protected from the users. There
One of the main tasks an Excel VBA programmer encounters is searching excel sheets for a specific value. While there are many different methods for doing a search, in this article I will only cover the basic method of using a For Next loop. In
In this article I will explain how to retrieve data from a website using a query table and VBA. Previously in the article Excel Getting Data From the Web I’ve explained how you can use Query Tables to import data from the web into an excel worksheet.
In this article I will explain how you can create drop down lists using data validation. Jump To: Creating Data Validation (Manually) Creating Data Validation (Using VBA) Selection Change Modifying, Adding, Inserting and Removing Items (Usin VBA) You can download the file and code related
In this article I will explain how to work with the Range and Cell objects. While the terms range and cells may be used interchangeably, they are two different objects, and have different functions and properties. There are two main notations for referencing ranges: Range(“A1:B1”) notation Range( Cells(1,
You have probably worked with file and folder dialogues before. Selecting a file to open choosing a path to save the current file choosing a directory path Although it would seem that the dialog itself does the saving and opening, but most dialogues actually don’t do any of that.