Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Sub Button1_Click()
Dim xVar(1 To 4, 1 To 3) For k = 1 To 4 ax = k + 1: bx = k + 2: cx = k + 5 xVar(k) = Array(ax, bx, cx)' error Next [a2:c5].Value = xVar End Sub this code figure out error. i want to work fast performance. and thus, i want to run without for loop. xVar(k,1 to 3) = Array(ax, bx, cx) or xVar(k,1:3) = Array(ax, bx, cx) how can i syntax????? *** Sent via Developersdex http://www.developersdex.com *** |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
workbook qustion | Excel Discussion (Misc queries) | |||
A Challenging Charting Qustion - Are there any Brainiacs Among Us? | Charts and Charting in Excel | |||
one qustion | Excel Worksheet Functions | |||
Newbie Qustion- how to divide sum of series by half? | Excel Discussion (Misc queries) | |||
Calculation Qustion | Excel Worksheet Functions |