PDA

View Full Version : Excel 2013 Compatibility



czhang78
02-05-2013, 06:26 PM
The old code I have for my program is:
For Each cell In Sheets("xxx").Range("xxx").Cells
However, when I run the program on Excel 2013, it says "Can't find project or library". Can Excel 2013 still recognize "cell"?

Aussiebear
02-05-2013, 08:18 PM
Does this work?

For each cel in Worksheets("Sheet1").Range("A1:A5")