Articles by Iqra Hasnain

VBA Howtos

1. How to Call Userform Initialize in VBA
2. Array List in VBA
3. How to Use Quotes in Strings in VBA
4. How to Count Rows in VBA
5. How to Install and Register MSCOMCT2.OCX File
6. How to Call Sub in VBA
7. How to Compare Strings in VBA
8. How to Return Array From Function in VBA
9. The Sum() Function in VBA
10. How to Exit Sub in VBA
11. How to Remove Duplicates in VBA
12. How to Add New Line in VBA
13. How to Refresh All Pivot Tables in VBA
14. How to Round Up Numbers in VBA
15. How to Check if Sheet Exists in VBA
16. How to Create Variable Range in VBA
17. How to Set Worksheets in VBA
18. How to Activate Worksheet in Excel in VBA
19. How to Open PDF in VBA
20. How to Protect Macro in VBA
21. Auto Filter With Multiple Criteria in VBA
22. How to Change Cell Color in VBA
23. How to Concatenate String in VBA
24. How to Count Columns in VBA
25. The VLOOKUP Function in VBA
26. How to Convert String to Number in VBA
27. Selection of Cells in VBA
28. Out of Memory in VBA
29. How to Copy File in VBA
30. How to Delete File in VBA
31. File System Object in VBA
32. How to Clear Clipboard in VBA
33. How to Create New Excel Sheet in VBA
34. Selection Paste Using VBA
35. How to Set Formulas for a Cell in VBA
36. Global Variable in VBA
37. How to Sort Data Range by Specific Column in Excel VBA
38. How to Use AND Operator in IF Statement in VBA
39. How to Delete a Row in VBA