PUBLIC MARKS with tag dictionary

Option Explicit Public Sub Test() Dim wb As Workbook Set wb = ActiveWorkbook Dim ws As Worksheet Set ws = wb.ActiveSheet Dim rng As ListObject Set rng = ws.ListObjects(1) Dim arr() As Variant arr = Application.Transpose(rng.DataBodyRange.Value) Dim d As Scripting.Dictionary Set d = GetUnique(arr) Dim tempD As Scripting.Dictionary Set tempD = New Scripting.Dictionary Set tempD = SortDictionary(d) Dim key As Variant For Each key In d.Keys Debug.Print key, d.Item(key) Next key End Sub Private Function GetUnique(ByRef arr() As Variant) As Scripting.Dictionary Dim v As Variant Set GetUnique = New Scripting.Dictionary On Error Resume Next For Each v In arr GetUnique.Add v, v Next v End Function Private Function SortDictionary(dicObject As Scripting.Dictionary, Optional xlSortOrder As xlSortOrder = xlAscending) As Scripting.Dictionary Dim obj As Object Set obj = CreateObject("System.Collections.ArrayList") Dim v As Variant With obj For Each v In dicObject .Add v Next v .Sort End With Dim tempDic As Scripting.Dictionary Set tempDic = New Scripting.Dictionary Dim k As Variant For Each k In obj tempDic.Add k, dicObject(k) Next k Set SortDictionary = tempDic End Function

Hello Paul Is there a way to return an ArrayList from a function, like a bellow? This is the code I have implemented Public Function ReturnArrayList() As ArrayList // or return type As Variant Dim alist As ArrayList Set alist = New ArrayList // Early Binding alist.Add “a” alist.Add “b” alist.Add “c” alist.Add “240” ReturnArrayList = alist End Sub Sub GetArrayList() Dim alist As ArrayList alist = ReturnArrayList() MsgBox alist(0) End Sub Thank you, Nishan Reply Paul Kelly Paul Kelly on December 24, 2019 at 7:56 am Hi Nishan, You need to use Set when returning an object.

Professions dictionary

Collins COBUILD Advanced Dictionary of American English (Interactive CDROM) pic Год выпуска: 2007 Версия: 1th Разработчик: Thomson ELT / Collins COBUILD Платформа: Windows, MAC Совместимость с Vista: полная Системные требования: -Windows 98, 2000, XP or Mac OS x - 64 MB RAM (128 MB recommended) - 400 MB available hard disk space - 800 x 600, 16-bit color display, minimum; 1024 x 768 recommended. - Sound car with speakers and a microphone - CD-ROM drive - QuickTime version 6.0 Язык интерфейса: только английский Описание: A valuable enhancement to the learning experience, the Collins COBUILD Advanced Dictionary Interactive CD ROM offers learners a fast and simple way to explore words and their meanings while working on a computer. SEARCH with definitions, sample sentences and more. “PopUp” Dictionary, Audio pronunciation with record and playback for pronunciation practice. “My Dictionary”: allows learners to create a personalized tool. Bookmarks: allow learners to save and organize vocabulary. Activity Guide includes interactive activities relating to the definition of words as well as the Usage, Word Link, Thesaurus, Word Web and Picture Dictionary features. "Grammar" open the list of Brief Grammar Reference features-a combination of text, images, and animations that explore key grammatical concepts. With innovations such as DefinitionsPLUS and vocabulary builders, the Collins COBUILD Advanced Dictionary of American English transforms the learner's dictionary from an occasional reference into the ultimate resource and must-have dictionary for language learners. Level: high-intermediate to advanced - DefinitionsPLUS * DefinitionsPLUS Collocations: Each definition is written in simple, natural English and shows which words are most typically used with the target word. * DefinitionsPLUS Grammar: Each definition includes the most representative grammatical patterns to help the learner use English correctly. * DefinitionsPLUS Natural English: Each definition is a model of how to use the language appropriately and idiomatically. - Vocabulary Builders * 250 "Word Webs" introduce related vocabulary through encyclopedia-like readings and art. * 1,500 "Word Links" expand the building blocks of English: prefixes, suffixes, and word roots. * 50 "Picture Dictionary": boxes illustrate key vocabulary and concepts. * 1,150 "Word Partnerships" highlight high-frequency collocations/word patterns * 725 "Thesaurus" entries offer synonyms and antonyms

Longman Dictionary Of Contemporary English 5th Edition (LDOCE5) pic Год выпуска: 2009 Платформа: Windows Совместимость с Vista: полная Язык интерфейса: только английский Таблэтка: Присутствует Описание: The Longman Dictionary of Contemporary English (5th edition), is the most comprehensive dictionary ever. * 230,000 words, phrases and meanings – more than any other advanced learner’s dictionary * 165,000 examples based on real, natural English from the Longman Corpus Network. * Clear definitions written using only 2,000 common words. * Over 18,000 synonyms, antonyms and related words. * Over 65,000 collocations. * The top 3,000 most frequent words in spoken and written English are highlighted to show which are the most important to know. * NEW Integrated Collocations Dictionary. Over 65,000 collocations will improve students’ fluency. * NEW Integrated Thesaurus. Over 18,000 synonyms, antonyms and related words will improve vocabulary range. * NEW Register Notes focus on the differences between spoken and written English. * Academic Word List highlighted. * Grammar and warning notes ensure that students avoid common errors. * NEW text design ensures students can find information fast.

homecoming - definition and synonyms Using the thesaurus noun [countable] homecoming pronunciation in British English /ˈhəʊmˌkʌmɪŋ/ Word Forms Contribute to our Open Dictionary 1 an occasion when someone returns to a place where they used to live, work, or study Her family celebrated her homecoming. Synonyms and related words Arrivals and entrances:arrivals, entry, homecoming...

Hunspell is the spell checker of LibreOffice, OpenOffice.org and Mozilla Firefox 3

Look up any word in the English language. You can also hear the correct pronunciation.

Impressive collection of smileys and their meanings.

Le dictionnaire des phobies. Il y en a pour tous les goûts.

a group of volunteers throughout the world began creating an open, free, online Japanese-English dictionary. The form and content of the dictionary are decided by the participants in the project. Among its features are the following: * Definitions that explain the meaning of words as completely as possible * As many examples as possible of each word in real contexts * Photographs and other illustrations, especially for entries about uniquely Japanese things * No restrictions on the type or range of vocabulary * No restrictions on the length of entries The dictionary has been named jeKai (je海), pronounced "jay-kai" or ジェーカイ.

“Blog This” feature allows bloggers and webmasters (a person or group) to include the illustrations and terminology found on www.visualdictionaryonline.com in their blogs only, as long as the site www.visualdictionaryonline.com is mentioned and the illustrations and terminology link back to this site

The Visual Dictionary is designed to help you find the right word at a glance. Filled with stunning illustrations labeled with accurate terminology in up to six languages, it is the ideal language-learning and vocabulary dictionary for use at school, at home or at work.

also has links to other dic by subject

user-editable encyclopedia for hashtags found on Twitter