I have a range, "MyRange", that consists of discontiguous cells, such as
A1, C1, D1, E1. (All cells are in a single row.) I can use:
For Each MyCell in MyRange
...
Next MyCell
However, I prefer to use MyRange.cells(1) or My.cells(1,1). This doesn't work. Any idea how to specify a value for the 3rd cell in MyRange?
Bookmarks