$$Excel-Macros$$ Re: Excel Chart Macro to Set Axis Values

Hello. Select axis, Format axis, set minimum to 1/1/10 and maximum to 4/30/10. HTH Daniel On 22 oct, 20:03, Wataridori wrote: > Hi all, > > I was wondering if there is a way to set the axis values of a scatter > chart to the maximum and minimum values given in the source data. For > example, wi

$$Excel-Macros$$ Re: Overflow error in Excel 2007 VBA

Hello. When computing, Excel uses intermediate variables. "1" and "4" being less than 32760 are considered as integers. the internal result variable is also considered as integer, whence error. Regards. Daniel On 30 juil, 08:46, Harmeet Singh wrote: > Couldn't figure out why but workaround i

$$Excel-Macros$$ Re: Escaping a foir loop

Randomize For i = 1 To 1000 Var = Rnd * 10 If Var < 5 Then GoTo myNext 'next instructions myNext: Next i or Randomize For i = 1 To 1000 Var = Rnd * 10 If Var >= 5 Then 'next instructions End If Next i Daniel On