Skip to content
Primary Menu
  • Officetricks.Com
  • Blog
  • App Store
    • International Users
    • Indian Users
  • Subscribe
  • About Us
  • Excel
  • Social Media
Collection Data Type Dictionary VBA Array

VBA – Create Array from Excel Range – 1 Dimension

April 27, 2022
Kumarapush

Excel Macro – Create 1D Array from Vba Array This is one of the easy methods to initialize an array. If you convert data in worksheet directly to vba array, then it will create a 2d array by default. If you would like to convert Excel range to Array of […]

Collection Data Type Dictionary VBA Array VBA Beginners

VBA – Add Items to Array – Dynamic Resize without erasing data

April 27, 2022
Kumarapush

How to add new item to existing array? In VBA, an array is always an fixed size of data values. If you have to add new item, then size of the field also has to be changed. Lets see an example: Consider you have an array like the below one: […]

Data Type Dictionary Excel

Excel VBA – Loop thru all Keys & Items in Dictionary

April 27, 2022
Kumarapush

Dictionary Object – Accessing all Keys & Items In this article, You can get code to access a Dictionary object key & item in a loop. There are 5 different methods to do this. Loop thru each Key by Directly accessing each key Using Index number Read each Item by […]

Data Type Dictionary Excel Excel VBA Macro

Excel VBA Dictionary Datatype – Create & Add Keys, Items

April 27, 2022
Kumarapush

Excel VBA Scripting.Dictionary “Dictionary” is a datatype similar to an array, but in addition it can hold a group of variable or objects. Another available data type similar to this is “Collection”. In short it can be called as an Indexed Array. You have to include a reference to “Microsoft […]

Dictionary Tricks

  • VBA – Add Items to Array – Dynamic Resize without erasing data
  • Excel VBA – Loop thru all Keys & Items in Dictionary
  • VBA – Create Array from Excel Range – 1 Dimension

Collection Tricks

  • VBA – Add Items to Array – Dynamic Resize without erasing data
  • Excel Vba Sort Array – Quick Trick using built in function

Data Type Tricks

  • VBA to Change File Encoding ANSI to UTF8 – Text to Unicode
  • VBA – Add Items to Array – Dynamic Resize without erasing data
  • Excel VBA Dictionary Datatype – Create & Add Keys, Items
  • Excel Vba Sort Array – Quick Trick using built in function
  • LET( ) Function in Excel
  • New Update – Very useful for Whatsapp Web Users
  • How to remove Drop down list in Excel?
  • How to create drop down list in Google sheets?
  • VBA Unhide all Sheets in Excel or with their Name – VeryHidden Worksheets
  • VBA Userform – Escape key to Close – Unload form
Dropdown Excel

How to remove Drop down list in Excel?

April 27, 2022
Kumarapush

Delete a Drop down data valition list in Excel A drop down list in Excel

Excel

How to create drop down list in Google sheets?

April 27, 2022
Kumarapush

Add Google Sheets Drop Down List Here are the steps to create a drop down

Excel VBA Macro Worksheet

VBA Unhide all Sheets in Excel or with their Name – VeryHidden Worksheets

April 27, 2022
Kumarapush

How to unhide all sheets in Excel using VBA code? To unhide all sheets in

Excel Keyboard Shortcut VB6

VBA Userform – Escape key to Close – Unload form

April 27, 2022
Kumarapush

Make VBA Userform to Close with Escape Key Usually developers add a command button to

Social Media Whatsapp

New Update – Very useful for Whatsapp Web Users

April 27, 2022
Kumarapush

WhatsApp Latest Update Here is a very good news for all those who are using

Dropdown Excel

How to remove Drop down list in Excel?

April 27, 2022
Kumarapush

Delete a Drop down data valition list in Excel A drop down list in Excel

Excel

How to create drop down list in Google sheets?

April 27, 2022
Kumarapush

Add Google Sheets Drop Down List Here are the steps to create a drop down

Excel VBA Macro Worksheet

VBA Unhide all Sheets in Excel or with their Name – VeryHidden Worksheets

April 27, 2022
Kumarapush

How to unhide all sheets in Excel using VBA code? To unhide all sheets in

Copyright All rights reserved