Mixing For i = x to y and j = z to y for lines and columns

[[email protected]]

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

[mcg]

[email protected] napisal(a):
> 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


try to change Range(Columns(j) & i)
into cells(i,j)
mcg

[Tom Ogilvy]

Sub TEST
For i = 4 To 32 Step 1
For j = 3 To 6
If Worksheets("Skew Matrix").Cells(i,j).Value = "" then

End if
Next i
Next j
End Sub

--
Regards,
Tom Ogilvy

"[email protected]" wrote:

> 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
>
>

[[email protected]]

Many thanks,
it seems ok, I have a small problem, but I should be able to sort it
Many thanks, I know understand the logic, what is always greater than
to find the solution!
regards
Daniel
Tom Ogilvy wrote:
> Sub TEST
> For i = 4 To 32 Step 1
> For j = 3 To 6
> If Worksheets("Skew Matrix").Cells(i,j).Value = "" then
>
> End if
> Next i
> Next j
> End Sub
>
> --
> Regards,
> Tom Ogilvy
>
> "[email protected]" wrote:
>
> > 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
> >
> >