View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected] daniroy@gmail.com is offline
external usenet poster
 
Posts: 39
Default Mixing For i = x to y and j = z to y for lines and columns

hello, this morning I have been explained how to use For expression for
columns definitions, but I am trying without success to mix it with For
expression for lines.
Right now code looks like
______________
Sub TEST
For i = 4 To 32 Step 1
For j = 3 To 6
If Worksheets("Skew Matrix").Range(Columns(j) & i).Value = "" And CODE
Next i
Next j
End Sub
_______________
Not working!
I was before that writing

If Worksheets("Skew Matrix").Range("C" & i).Value = "" And CODE

and I do not want to repeat it for every columns...
help??
many thanks!
Daniel