D
danwPlanet
How can I program the cursor to do what happens when I press the Down
Arrow key, with regard to ignoring hidden rows?
If I use
[VBA] ActiveCell.Offset(1, 0).Select
....the cursor moves down to the next numerical row, which may be a
hidden row.
If I use
[VBA] SendKeys "{DOWN}"
....it behaves like CTRL+SHIFT+Down Arrow, selecting all the contiguous
non-blank cells below the active cell. That's not as advertised,
right?? (I have to remember not to execute this statement while in the
VBA editor, because from there it just moves the VBA editor's cursor.)
This is in Excel 2000.
Arrow key, with regard to ignoring hidden rows?
If I use
[VBA] ActiveCell.Offset(1, 0).Select
....the cursor moves down to the next numerical row, which may be a
hidden row.
If I use
[VBA] SendKeys "{DOWN}"
....it behaves like CTRL+SHIFT+Down Arrow, selecting all the contiguous
non-blank cells below the active cell. That's not as advertised,
right?? (I have to remember not to execute this statement while in the
VBA editor, because from there it just moves the VBA editor's cursor.)
This is in Excel 2000.