Posts by P.Moreira • 46 points

• 1

  votes

  1

  answer

  1114

  views

  A: Runtime error: 9 - subscribed out of range 2

  What I see first is that the internal is did not have its next try the code below. ' Calcul des cumuls annuels sur l'année hydrologique (1er septembre au 31 aout) For k = 1 To nbannees - 1 For j = 1…

  excel vba

  answered 6 years, 5 months ago P.Moreira 46

• 1

  votes

  1

  answer

  4369

  views

  A: How to concatenate variable with formula in Excel?

  Marcio, good afternoon! In my view it is possible and this certain, because it is necessary according to its need of dynamism when building the formula. So follow my suggestion of how I believe it…

  excel vba string-concatenation

  answered 7 years, 2 months ago P.Moreira 46

• 0

  votes

  1

  answer

  64

  views

  A: VBA Excel Reference Tools?

  Install Adobe Acrobat Reader version 7 on your machine.

  vba

  answered 7 years, 2 months ago P.Moreira 46

• 1

  votes

  1

  answer

  922

  views

  A: Save query results to an array

  Your problem is using the recordcount property as a check for your [FOR]. recordcount will only have information after you have gone through recordset. As a solution I suggest: option 1: Before…

  sql array excel vba ms-access

  answered 7 years, 2 months ago P.Moreira 46