Free excel vba sample codes download

But you can not open. Can you explain the Difference between Array and Loops…I mean in what scenarios we use these. Could you please explain me in terms of Interview point of and practical work scenario with better examples if possible. Example: If you want to format the a Range contains values less than zero in red color, no need write one statement for checking one Cell. You can avoid this using loops and one statement enough to do the same task for entire Range.

We will see these topics with more explanation in our blog soon. And will upload the examples on pivot table ASAP. I am facing lot of problem in some of my official daily tasks in terms of Reporting and wasting time bcz of manual work. Thank you very very much and can i get the exact task solution for TASK 3? And can you post our last class project?. Once again thanks for your support. Please upload more example files as all of our batch mates are waiting eagerly and getting calls frequently.

If possible kindly do alternate instead of slice usage as most of us not having excel I told to all and they are following it seems……. It is very nice specially its good for beginers. Once again thanks for sharing your knowledge with us. Added a simple dashboard, click on the Read More for more explanation on this simple dashboard. Added a simple Interactive dashboard. You can have a look and ask me if you have any questions. Dashboard is really nice and thank you so much for uploading with out slices for better understanding.

Hi Krishna, I do not have any predefined templates. Please let us know if you want us to prepare now. Thanks for file, but can you be able provide any Excel files which has code in it, and will not work on Excel Actually I am dealing with VBA code changes while migrating the Excel files to Excel format, I need sample issues files for training, can you please help me with them. I need your assistance for creating a macro which can take a screenshot and then convert in to pdf of a link s in website and also download excel files in those links.

Highlight all the Blank Cells Invisible Space. UsedRange If rng. Max Selection Then rng. It will check all the selected cells and highlight the cell with the maximum value. Min Selection Then rng. It will check all the selected cells and highlight the cell with the Minimum value. Highlight Unique Values. AddUniqueValues uv. This codes will highlight all the cells from the selection which has a unique value. Highlight Difference in Columns.

ColumnDifferences ActiveCell. Using this code you can highlight the difference between two columns corresponding cells. Highlight Difference in Rows. RowDifferences ActiveCell. And by using this code you can highlight difference between two row corresponding cells.

Print Comments. Sub printComments With ActiveSheet. Print Narrow Margin. InchesToPoints 0. Print Selection. Print Custom Pages. Please try again. Hide all but the Active Worksheet. Worksheets If ws. Name Then ws.

Unhide all Hidden Worksheets. Worksheets ws. Delete all but the Active Worksheet. Protect all Worksheets Instantly. Resize All Charts in a Worksheet. ChartObjects i. Insert Multiple Worksheets. Protect Worksheet. Protect "mypassword", True, True End Sub.

Un-Protect Worksheet. Unprotect "mypassword" End Sub. Sort Worksheets. Name Then Sheets j. This code will help you to sort worksheets in your workbook according to their name. Protect all the Cells With Formulas. SpecialCells xlCellTypeFormulas. To protect cell with formula with a single click you can use this code. Delete all Blank Worksheets. Worksheets If Application. CountA Ws. Delete End If Next Application. Unhide all Rows and Columns. Sub UnhideRowsColumns Columns. Disable Page Breaks.

Workbooks For Each Sht In wb. Worksheets Sht. Create a Backup of a Current Workbook. Close all Workbooks at Once. Copy Active Worksheet into a New Workbook. Worksheets 1 End Sub. Active Workbook in an Email. CreateItem 0 With OutMail. Add Workbook to a Mail Attachment. Dialogs xlDialogSendMail. Show End Sub. Welcome Message. Closing Message.

Don't forget to check other cool stuff on excelchamps. Count Open Unsaved Workbooks. These codes will help you to manage and make some changes in pivot tables in a flash.

Hide Pivot Table Subtotals. PivotTables ActiveCell. PivotFields pf. Refresh All Pivot Tables. PivotTables pt. RefreshTable Next pt End Sub.

Create a Pivot Table. Auto Update Pivot Table Range. PivotTables PivotName. Sub activateGetPivotData Application. Use these VBA codes to manage charts in Excel and save your lot of time. Change Chart Type. Paste Chart as an Image. Add Chart Title. Some of the codes which you can use to preform advanced task in your spreadsheets.

Create a Table of Content. Convert Range into an Image. Sub PasteAsPicture Application. Insert a Linked Picture. Sub LinkedPicture Selection. Use Text to Speech. Sub Speak Selection. Speak End Sub. Activate Data Entry Form. Sub DataForm ActiveSheet. ShowDataForm End Sub. Use Goal Seek. Activate With ActiveSheet. Range "C7". Convert all Formulas into Values. HasFormula Then MyCell. Remove Spaces from Selected Cells. Remove Characters from a String. Add Insert Degree Symbol in Excel. Value Then ActiveCell.

Reverse Text. Value End Function. Activate R1C1 Reference Style. Activate A1 Reference Style. Sub ActivateA1 If Application. This macro code will help you to activate A1 reference style without using Excel options. Insert Time Range. Select Next i End Sub. With this code, you can insert a time range in sequence from to Convert Date into Day. Convert Date into Year. Remove Time from Date. Int Rng. Value End If Next Selection. If you have time with the date and you want to remove it then you can use this code.

Remove Date from Date and Time. Value - VBA. Fix Rng. Value End If NextSelection. It will return only time from a date and time value. Convert to Upper Case. IsText Rng Then Rng. Convert to Lower Case. Convert to Proper Case. Proper Rng. Convert to Sentence Case. Remove a Character from Selection. Word Count from Entire Worksheet. Trim rng. It can help you to count all the words from a worksheet. Remove the Apostrophe from a Number. Sub removeApostrophes Selection.

Value End Sub. Remove Decimals from Numbers. Multiply all the Values by a Number. IsNumber rng Then rng. Add a Number in all the Numbers. Just like multiplying you can also add a number into a set of numbers. Calculate the Square Root. Calculate the Cube Root. Add A-Z Alphabets in a Range. Convert Roman Numbers into Arabic Numbers. IsNonText rng Then rng. Remove Negative Signs. Replace Blank Cells with Zeros. Share 0. Tweet 0. About the Author. Hello guys thanks.. Hi and thanks for the previous examples!

Any idea how I could solve this? Kath Reply. Dear Sir Please, what is the error in this program? Thanks for sharing Reply. There is the change in below point Please help.

Macro1 End Sub Reply. Select End Sub Reply. Is this something you can help me with? WK Reply. I must say. I know a bit about Excel. This is most enlightening. Well done. Cheers Reply. If you can help me with some tips I would be grateful. Thank you in advance. Hi Everyone, Can someone help me with my macro. Thank you so much. Hi Puneet Nice effort to allow users to use your codes.

I want to select range of cells as range and wish to give them some formula based on vlookup… For example I have in one sheet purchase entries done On the next page I am doing the calculation of gst… So every time I have to change the row reference…As one column I have 2. Thankyou for this!!. Regards, Vinay Verma Reply. This one is golden Reply. Thanks Puneet, Excellent Work. You have given me the start I have been looking for.

Many thanks, Reply. Looks similar but not the same. Tried two subs — neither worked — at least not in Hey Pwyller, which two? How to import a tif,pdf,img,etc… these types files by clicking button Reply.

Hi Puneet, Thanks for gathering all this code! Macro vba made in excel to calculate MRP , and to facilitate the management of stocks and of production in the manufacture context, you can read more about this macro excel in excel mrp. Macro vba made in Excel allows you to list any type of file, indicating the folder in which it is found ,its size and its date of creation , you can read more about this macro excel in excel list files.

Excel Macro - List and organize files. Excel Macro - List and organize files- Format. At first, you will see an example of an operating macro in excel, it consists on make the task automatic and give format to an specific report, you can read more about this macro excel in excel macro example. Excel planner. Project Scheduling Software. Designed for Zen Cart versions 1. All template packages include the admin settings needed to make the File Name: col File Name: Excel Training - Level 1.

File Name: timesheet.