Solved: Correct syntax

[ertan]

Need help for using variable in selection


For Each c In DataSheet.Range("A13:A" & DataSheet.Range("A65536").End(xlUp).Row)
I would like to set starting row "A13" to variable.. how would I do that?

For example if I set startrow=activecell.row

What would be the correct syntax to use startrow in above code..

Regards
Ertan

[jindon]

Hi
sounds like




For Each c In DataSheet.Range("A" & startrow & ":A" & DataSheet.Range("A65536").End(xlUp).Row)

[ertan]

Thank you , that is it :hi:

It is solved , but I cannot mark as solved..

Regards

Ertan