VBA: For each cell does not work - Range is change and Out of context
- by user1744638
I have problem with for each cell.
I have like that :
Set cur_sheet = Worksheets("Sheet2")
Set Rng = cur_sheet.Range("A1", "C1523")
For Each cell In Rng.Cells
a=1
next cell
if there is row 370 that I have error message " Run time error 94" Invalid use of Null
So I do not know what can I change. This row should be ok, filled with text.
Why this FOR is not working properly and change range !! ? 370 rows are proceesed correctly, than it is error.
Do you have any ideas ?
