How can i select records in excel using macro procedure?

Answer There are several ways to select cells using VBA code, either individually, by rows, and/or by columns. It would take several pages of documentation to cover the basics of the very general questio... Read More »

Top Q&A For: How can i select records in excel using macro p...

How to Disable One Macro in Excel 2003 Using the VBA?

Macros are snippets of Visual Basic for Applications (VBA) code that let a user automatically perform repetitive tasks by clicking a button or pressing a key combination. When certain macros are no... Read More »

Using macro, how do i refresh all worksheets in excel file?

First of all, you did not specify which version of MS-Excel you are using. So I will assume it to be 2003 or earlier. Here is the basic information to refresh imported data.Refreshing Data-------... Read More »

How to Password Protect an Excel Worksheet Using a Macro?

The Visual Basic editor provided with Microsoft Excel gives more advanced users the tools necessary to create almost limitless macros to customize the way Excel works. A simple macro can password-p... Read More »

How to Hide My Protection Password in an Excel Worksheet Using a Macro?

Microsoft Excel is a spreadsheet application that is part of the Microsoft Office suite that is used to produce reports, graphs, line charts, histograms and pivot tables. It is supported by Visual ... Read More »