How to write Property Let for the single elements of an array - sub array - order by pertinence

Fluidigm Reports Financial Results for the Fourth Quarter and Fiscal Year 2010

Q4 Revenue Up 36%; Full Year Revenue Up 32%.

Press published on the March 9th, 2011 - 5:00 AM ET

BigFoot Investments Unveils Professional Portfolio Management Toolkits for Advisors

Platform Designed to Equip Advisors Seeking to Regain Control of Investment Process.

Press published on the May 20th, 2013 - 8:04 AM ET

Equinix and NetApp Enable Security and Scale for Flexible Cloud Compute Environments

NetApp Private Storage for AWS delivers performance, agility and control for global cloud deployments via Platform Equinix.

Press published on the March 27th, 2013 - 6:00 AM ET

NLT Technologies Introduces High-Resolution Multi-View 2D/3D Display with HxDP Technology for Enhanced Stereoscopic Viewing Experience

NLT Technologies (NLT), together with its sales and marketing channels in the Americas and Europe, Renesas Electronics America (TSE:6723) and Renesas Electronics Europe GmbH, today announced the successful ...

Press published on the May 14th, 2012 - 6:00 AM ET

SES: Recurring Revenue and EBITDA Growth of 2.8% and 3.1% Respectively

Profit of the Group up 26.8%.

Press published on the February 17th, 2012 - 1:00 AM ET

SEMATECH Demonstrates Breakthrough Solutions for Critical Materials in Next Generation Devices at IEDM 2012

Technical Papers Showcase Innovations in Resistive RAMs, Reliability, quantum well III-V and beyond CMOS Devices for Dimension Scaling and Material Technology.

Press published on the December 10th, 2012 - 2:47 PM ET

Prognoz Collaborates with the African Development Bank to Bring Africa to the Global Information Economy

Transformative Business Intelligence Solutions to Boost Information Sharing and Effectiveness for 54 African Countries and 16 Regional Organizations.

Press published on the April 16th, 2013 - 6:10 AM ET

How to write Property Let for the single elements of an array

Hi all, thanks to Bob's and other people's suggestions, I'm now able to assign to all elements of an array property in a class module. But what if I need to assign to a *single* element? It looks like I have to Redim it each time... Example: ' ...

Message posted on the March 16th, 2010 - 7:50 AM ET

Problem with the code, probably with Private Sub Worksheet_Calculate()

Hello everyone. I'm rather VB illiterate. Usually I compile fragments of code found somewhere on the internet and try to adopt them to my needs. I did something like that this time also. Unfortunately there is some problem. Because I haven't been ...

Message posted on the January 19th, 2010 - 7:05 AM ET

Passing values to an array

Can I pass values (e.g. a concatenated string of days) to an array from another function? This sub works: Sub xArray1() Dim MyWeek, MyDay MyWeek = Array("Mon", "Tue", "Wed", "Thu", "Fri", ...

Message posted on the February 3rd, 2010 - 7:41 AM ET

compile error: expected array.

I got this code from an access forum and when I compile it I get an error saying expected array. This is a module: Sub ShowUserRosterMultipleUsers() Dim cn As New ADODB.Connection Dim rs As New ADODB.Recordset Dim i, j As Long Set cn = ...

Message posted on the June 26th, 2010 - 7:22 PM ET

VBA Offset (trying to resize an element within nested array)

I'm running into a problem with application.match, and I'm thinking it may be because my comparison array is an array equivalent to a whole column in 2007 (1MM+ rows) so I want to shorten my array to only include the area with values. However, my ...

Message posted on the July 15th, 2009 - 8:15 PM ET

Save Array in memory

Hi NG I'm using bellowed macro. Each time I'm opening my User Form = UF, I must rum this macro for getting array: data() Is there a way I can load the Array [data()] in memory, so I only run the macro when opening the file and Erase data() ...

Message posted on the February 27th, 2011 - 10:22 AM ET

2D array of strings problem

I have the following erroneous subroutine: '==Sub DoStuff (A as Integer, B as Integer) Dim (A, B) as String ' This creates an error! End Sub '= Is it possible to create a 2D array whose size depends on the values of A and B above? I'm ...

Message posted on the February 19th, 2011 - 1:18 AM ET