This Excel tutorial explains how to compare worksheets using Compare File function. You may also want to read: Excel VBA compare worksheets Excel Compare Worksheets using Compare File Compare worksheets is to compare worksheets of similar structures but different values. Excel has a built it function called Compare File in Office Professional Plus 2013 or Office 365 ProPlus (click here i...

This Excel tutorial explains how to use Excel VBA to compare worksheets. You may also want to read: Excel compare Worksheets using Compare File Excel compare worksheets Compare worksheets is to compare worksheets of similar structures but different values. Excel has a built it function called Compare File in Office Professional Plus 2013 or Office 365 ProPlus. After comparison is complete,...

This Excel VBA tutorial explains how to export Excel to Word. You may also want to read: Export Excel to PDF Excel VBA export Excel to Word In the previous post, I demonstrated how to export Excel to PDF, which is very easy because there is already a built in function to do that (using Save As and choose PDF). However, there is no built in function to export Excel to Word. Fortunately Exce...

This Excel tutorial explains how to protect workbook with password with VBA and without VBA. 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 worksheets (do not allow insert, delete, rename, move, copy, hide or ...

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

This Excel tutorial explains how to add password to workbook with VBA and without VBA. You may also want to read Add password to all Excel workbook in folder 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 al...

This Excel tutorial explains how to check Excel #N/A cells using worksheet formula ISNA and VBA Function. You may also want to read: Excel IFERROR Function Cause of Excel #N/A #N/A is usually caused by lookup related functions where a value cannot be found in lookup table. Lookup Functions include Vlookup, Match, HLookup, Lookup. Another common cause is that when you use an Add-In formu...

This Access tutorial explains how to delete blank rows and blank cells in Excel before import into Access. You may also want to read: Excel Delete Blank Rows Import Chinese CSV to Excel Import Excel File into Access When you import an Excel file into Access, you may come up with several issues regarding Excel blank cells. Excel blank cells are not considered as Null value in Access Ex...

This Excel tutorial explains how to select multiple worksheets using Excel VBA Worksheet.Select Method and using Array. You may also want to read: Excel export Excel to PDF with and without VBA Select multiple worksheets in Excel In Excel worksheet, there are two ways to select multiple worksheets Method 1. Hold down Ctrl and then left click the mouse on each worksheet tab  ...

This Excel tutorial explains how to add page number in footer. E.g. add page number to all worksheets, add page numbers to specific worksheets. Excel add page number in footer to one worksheet Select the worksheet you want to add page number in footer Navigate to PAGE LAYOUT tab > Print Titles   Click on Header/Footer tab > select the desired Footer format > OK ...