PUBLIC MARKS from cascamorto

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

Contents : 1 Quick Guide to the VBA ArrayList 2 Description 3 Download the Source Code 4 Declare and Create the VBA ArrayList 4.1 Late Binding 4.2 Early Binding 4.3 VBA ArrayList Automation Error 5 Adding Items to the VBA ArrayList 6 Reading through an ArrayList 7 Sorting 8 Cloning the VBA ArrayList 9 Copying from an VBA ArrayList to an Array 10 Writing Directly to a Range 11 Array to a VBA ArrayList(1D) 12 Remove All Items from the ArrayList 13 What’s Next?

import matplotlib from matplotlib import cm # See https://stackoverflow.com/a/65677873 for None usage cmap = cm.get_cmap('Paired', None) # PiYG print('cmap = n ') print(cmap) for i in range(cmap.N): rgba = cmap(i) # rgb2hex accepts rgb or rgba print(matplotlib.colors.rgb2hex(rgba))

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.

Le partitionnement est une étape clef de l'installation de GNU/Linux et de la prise en compte des supports de stockage de données. Cette documentation détaille le fonctionnement du partitionnement sous GNU/Linux. Cependant, il n'est pas nécessaire de connaître tous ces détails pour l'installation et l'utilisation d'une distribution « grand public » comme Ubuntu ou Mandriva, où le partitionnement peut être fait automatiquement.

Le partitionnement La question rituelle, et inévitable, lorsqu'on installe Debian, c'est comment organiser mes partitions...

L'utilitaire en question se nomme RMPrepUSB, il nous permet de faire pleins d'opérations dont le formatage, que ce soit en NTFS, en FAT32 ou en FAT16. De plus, il permet de changer le type d'amorçage et de rendre la clé bootable. Cet utilitaire possède également différents modules externes pour faire la défragmentation des clés USB et l'émulation de PC avec QEMU pour tester les clés bootable une fois complété. Avec l'installation de grub4dos et de Easy2Boot, il vous sera alors possible d,y déposer vos fichiers .iso et de les démarrer pour en faire l'installation. Ceci permet alors de gagner beaucoup d'espace, plus besoin de graver de disques pour faire l'installation de Windows, Linux ou utiliser d'autres utilitaires bootable.

SystemLook will recognize the following commands (also called 'contexts' by the tool): :dir :file :reg :service :process :filefind :folderfind :regfind :env :assoc :contents :comment SystemLook also has built-in functions called Presets, that perform a dedicated function without any options or input. Presets start with a double colon (::). The following Presets are available (more information below): ::csinfo ::safeboot ::env

Leaflet is a modern open-source JavaScript library for mobile-friendly interactive maps. It is developed by Vladimir Agafonkin with a team of dedicated contributors. Weighing just about 33 KB of JS, it has all the features most developers ever need for online maps. Leaflet is designed with simplicity, performance and usability in mind. It works efficiently across all major desktop and mobile platforms out of the box, taking advantage of HTML5 and CSS3 on modern browsers while still being accessible on older ones. It can be extended with a huge amount of plugins, has a beautiful, easy to use and well-documented API and a simple, readable source code that is a joy to contribute to.

Créez des sondages. Obtenez des réponses.

Floss Manuals est une plateforme de partage et de co-création plurilingue. Floss Manuals met à la disposition du grand public et des professionnels une collection de livres en français sur les logiciels, la culture libre et le matériel libre. S'appuyant sur la communauté d'utilisateurs de ces outils, notamment les auteurs, éditeurs, artistes, développeurs de logiciels et activistes, ces livres sont consultables librement en différents formats (pages web, pdf et epub).

Virtual Router is a free, open source software based router for PCs running Windows 8, Windows 7 or Windows Server 2008 R2. Using Virtual Router, users can wirelessly share any internet connection (Wifi, LAN, Cable Modem, Dial-up, Cellular, etc.) with any Wifi device (Laptop, Smart Phone, iPod Touch, iPhone, Android Phone, Zune, Netbook, wireless printer, etc.) These devices connect to Virtual Router just like any other access point, and the connection is completely secured using WPA2 (the most secure wireless encryption.)

e-loue est une plateforme Internet simple et performante permettant à n’importe quel particulier ou professionnel de mettre en location ses objets, et chercher des objets à louer.

Zilok : 1er site de location de particuliers et professionnels

jedonne.org, le site de la solidarité et du don d'objets Vous voulez vous séparer de ce qui vous encombre, mais vous ne voulez pas jeter ces objets encore en bon état ? Offrez-leur une seconde vie ou faites le bonheur d'un bricoleur en les donnant ! Que vous soyez en France, en Belgique, au Canada, en Afrique, en Asie ou ailleurs sur la planète, ce site est fait pour vous, il suffit de s'enregistrer et de déposer une offre de don, c'est gratuit, que ce soit pour le donneur ou pour le receveur. Vous recherchez un objet ? Parcourez les annonces, elles sont classées par catégories pour que la recherche soit plus simple. Si un objet vous intéresse, il suffit de vous enregistrer pour avoir accès aux coordonnées de l'annonceur.

Free PDF Compressor is a free PDF compression software to enable you to effectively reduce the size of PDF files. Software is simple and easy to use, select an existing PDF file, and hit button "Compress", a compressed PDF file wiil be created, page by page, a progress bar will show progress of the whole compression process. This software is completely freeware, free for personal and non-commercial use.

ACCUEIL WORD POWERPOINT RESSOURCES FORUMS

To continue my fine tradition of optimizing MS’s latest OS, I have here my findings to date. If you are looking for Windows 7 Retail information, you are almost in the right spot. Before adjusting your service settings, ensure that your system has already installed all updates by “checking now” for any available updates via Windows Update. At this time, it is best for you to ensure that all services are set to the default values before updating your system.

I wanted to create a series of pictures representing mathematical shapes on white background, like a "tribute to mathematics" that I often use in my work. I chose the "strange attractors" for their dynamic forms and "chaotic feel". Because I'm not a mathematician, I relied on several sites. Including one especially, very complete with free plugins for Cinema 4D making possible to configure these shapes easily. The site is in German, but Google translate did the job very well, so many thanks to the author ! edit : workflow tutorial here ! edit : series finally available for printing on limited edition here !

As a tribute to mathematics, freelance illustrator and digital artist Chaotic Atmospheres, aka Istvan, set out to illustrate mathematical attractors in their most dynamic parameters. The result is “Math : Rules”, a collection of “strange attractors” represented in their 3-dimensional forms. In mathematics, an attractor is a region in an n-dimensional space which changes over time according to an evolving and approaching variable. “Strange attractors” are specials kinds of attractors constructed from more complicated sets with fractal structures; they are less predictable and more “chaotic”. Although based on mathematical formulas, Istvan’s goal isn’t to deduce any scientific breakthroughs; rather, it’s simply to produce aesthetically pleasing images that speak to the spectator. No ideas are imposed, giving each spectator complete freedom to interpret what they see. Istvan has long abandoned the idea that the concept within an image is more important than the image itself. Instead he finds experimental subjects and then creates images that enhance their most interesting forms. Based out of Geneva, Istvan now focuses primarily on 3D nature-themed collections created using generative art techniques. His collections have attracted the attention of diverse audiences and have been featured many times on Behance as well as on numerous other sites and blogs.

Free Online OCR Use Optical Character Recognition software without installation on your computer. Recognize text and characters from PDF scanned documents (including multipage files), photographs and digital camera captured images. Free Online OCR service supports 32 recognition languages. Convert scanned PDF to Word, Txt, Rtf Extract text from image (JPG, JPEG, BMP, TIFF, GIF) and convert into editable Word, Text, Excel, PDF, Html output formats. Converted documents look exactly like the original - tables, columns and graphics. Free OnlineOCR.net is a free service in a "Guest mode" (without registration) that allows you to convert 15 images per hour.