For Next + Range("A2:G2") + Call mysub

[ZuluNation]

Hell all users !! I am a new user so i salute everyone. This forum seems full like the old MS forum..!!

i have a little question , probably easy..
i make this and it works fine....

Dim aWB As Workbook
Dim aWS As Worksheet
Dim i As Long
Set aWB = ThisWorkbook
Set aWS = aWB.Worksheets("Main")
For i = 4 To 80 Step 4
aWS.Range("D" & i).Value = (aWS.Range("H7").Value - aWS.Range("C" & i).Value) / aWS.Range("O4").Value
aWS.Range("B" & i).Value = (aWS.Range("G7").Value - aWS.Range("A" & i).Value) / aWS.Range("O4").Value
Next


but...what if i would like to indicate a range...like this (syntax not working!) .....aWS.Range("A" & i : "H" & i).CalculateRowMajorOrder ???
and if i want to call a sub inside the For Next .. would it be possible to propagate the > i < to the called sub ???

Thanks who can help !! Please if anybody knows if excel-dna can multithread a for next ..tx !
Paolo

[dangelor]

Try include the colon in the quotes.

Please Login or Register  to view this content.

[ZuluNation]

tx ..the i becomes white !! anything about the other problem ??

[dangelor]

Possibly something along the lines of...

Please Login or Register  to view this content.

[ZuluNation]

Perfect ! ..couldn't work without this..

Option Explicit
Public i As Long

Ty dangelor !