Array range error question - sub array - order by pertinence

SimCorp Dimension User, American Century Investments, Grows AUM from $88 to $118 Billion

Centralization of position-keeping in SimCorp Dimension provides single authoritative source of data to support firm’s investment strategy for expansion.

Press published on the August 9th, 2012 - 7:00 AM ET

SES Reports Continued Growth Boosted by New Markets

SES S.A. (Paris:SESG) (LuxX:SESG) reports financial results for the six months ended 30 June 2012. FINANCIAL HIGHLIGHTS Revenue of EUR 891.9 million An ...

Press published on the July 27th, 2012 - 12:25 AM ET

Schlumberger Announces Second-Quarter 2012 Results

Schlumberger Limited (NYSE:SLB) today reported second-quarter 2012 revenue of $10.45 billion versus $9.92 billion in the first quarter of 2012, and $8.99 billion in the second quarter of 2011. Income from ...

Press published on the July 20th, 2012 - 4:00 AM ET

DTS and SRS Labs Announce Stockholder Election Deadline

DTS, Inc. (Nasdaq:DTSI), a leader in high-definition audio, and SRS Labs, Inc. (Nasdaq:SRSL), a leader in audio processing and enhancement technologies, today announced that SRS stockholders that wish to make an ...

Press published on the July 2nd, 2012 - 5:08 PM ET

PetroVR 2012 Is Here: 18 New Capabilities Accelerate Petroleum Exploration and Production Decisions with Transparency, Consistency, and Robust Decision Assurance

Caesar Systems announced the release of PetroVR 2012, version 10.1, decision assurance software for the petroleum exploration and production (E&P) sector of the oil and gas industry. PetroVR 2012 includes 18 ...

Press published on the June 27th, 2012 - 3:09 PM ET

Nexon Delivers ‘Vindictus’ Game Updates on Schedule with Autodesk Suites

Autodesk, Inc., (NASDAQ: ADSK) has announced that Nexon (TSE: 3659), a world leader in free-to-play online games uses Autodesk Entertainment Creation Suite to regularly update “Vindictus” (Mabinogi ...

Press published on the June 21st, 2012 - 6:30 AM ET

Accelerating Forex Trading to the Next Level with FastMatch

FXCM Inc. and Credit Suisse Group AG announced today the upcoming launch of FastMatch. FastMatch is a new Electronic Communication Network (ECN) for foreign exchange trading. FastMatch strives to offer its customers ...

Press published on the June 19th, 2012 - 6:05 AM ET

Array range error question

When i try to redim my array i get an out of range error. can someone tel me why? Cells A1..A10 are filled with strings. thanks much Sub Get_names_array() Dim names_array() As Variant 'dynmanic Dim j As Long ReDim names_array(5, 1) j = 0 ...

Message posted on the March 24th, 2010 - 5:37 AM ET

Search faster using array - But it slows down

Hi, the macro below builds number and then checks the next set it builds against all the other sets it has built to see if there is a match of more than 4 numbers. I expected it to be fast, it is, at the beginning... but slows down dramatically the ...

Message posted on the October 19th, 2009 - 8:07 AM ET

maximum of currency array?

I lift a worksheet range into an array and determine its maximum but it doesn't work, the results is always zero (its initial value): Sub curtest() Dim currencyarray As Variant Dim currencymax As Variant currencyarray = ...

Message posted on the May 9th, 2009 - 12:04 PM ET

Help requested to finish Array code

2003, 2007 Wish to capture multi-position/values of " ~ " in MainS (via Range("A1".Value = Position(i).Value ) MainS = "~972552~2~~3" (which is the OrigStr below, with all operators replaced with "~" ...

Message posted on the April 30th, 2009 - 7:43 PM ET

compile error: array or custom type expected

Hi, I'm getting a compile error, array or custom type expected, at this sub: Private Sub ignorarSempre_Click() ' this line appears highlighted and the sub doesn't run Dim arg(3) As Variant arg(0) = termo.Text arg(1) = "IGNORADO ...

Message posted on the January 28th, 2009 - 7:20 AM ET

Type mismatch: array or user-defined type expected

Hi Everyone, can you help with next problem. Here is variable declaration in sub rutine: Sub PVT_OIL_PB(ByVal TPB As Double, ByVal GAMAGPB As Double, ByVal GAMAOPB As Double, ByVal PSPB As Double, _ ByVal GORPB As Double, ByRef CAPB() As Double, ...

Message posted on the March 23rd, 2010 - 7:38 AM ET

Data range in Array worksheets

Hi, After several attempts to work around but fails to run the complete codes Thus, I need help to join the 2nd part of vba codes below so that I can make the changes in each sheet("P+L") of every workbook in J folder, thereafter make the ...

Message posted on the January 30th, 2010 - 12:50 PM ET