This Excel VBA tutorial explains how to use Range.PasteSpecial Method to paste special such as paste values. Excel VBA Range PasteSpecial Method In Excel worksheet, if you copy a Cell and then Paste Special, you can see a list of options. The most commonly used Paste Special is Paste Values, in order to remove all the formula. In Excel VBA, Paste Speical is done through Range.PasteSpecial Method. Syntax of Range.PasteSpecial Method Range.PasteSpecial(Paste, Operation, SkipBlanks, Tran...

This Excel VBA tutorial explains how to use Worksheet.Select Method to select a single worksheet or multiple worksheets. Select worksheets in Excel When you click on a worksheet tab, the worksheet is highlighted. To select multiple worksheets, you can hold down Ctrl and then left click the mouse on each worksheet tab. To select all worksheets at once, right click on one of the sheet, and then click on Select All Sheets One practical use of selecting multiple worksheets is to print sel...

This Excel VBA tutorial explains how to use Workbooks.Open Method to open another workbook. Excel VBA Workbooks.Open Method Workbooks.Open Method is useful when you try to open another Workbook using VBA. For example, you can open a workbook > format the spreadsheet > close the workbook automatically. There are a lot of rarely used arguments for Workbooks.Open Method. As most of them are self explanatory, I will demonstrate some common uses of the Method. Syntax of Workbooks.Open Method...

This Excel VBA tutorial explains how to use Workbook.SaveAs Method. You may also want to read: Excel VBA convert CSV to Excel Excel VBA Workbook.SaveAs Method VBA Workbook.SaveAs Method is same as the action Save As   The options under Tools are also available in VBA Workbook.SaveAs Method.   For example, we can add password to workbook. To understand what Workbook.SaveAs Method is capable of, let's see what arguments it has. Syntax - Excel VBA Workb...

This Excel VBA tutorial explains how to use VBA to protect worksheet with password. You may also want to read: Excel VBA hide worksheet with password (xlVeryHidden) Excel VBA Add password to Excel workbook in folder Protect VBA code with password Different kinds of workbook protection There are several kinds of protection in Excel. Add password to workbook. Users are asked to open the Excel file with password. Protect workbook with password. Protect the structure of all w...