Moving within a range, using a macro!!

  • Thread starter Thread starter Bob Westaby
  • Start date Start date
B

Bob Westaby

I have a macro that says, Range("B1").Select, now I want to move within a
range automatically,and I want to be able to exit by hitting the ESC button.
The spreadsheet looks like this:
A B C D
1 Beginning 10000 10000 10000
2 Today's
3 Total 10000 10000 10000
4 Sales

There are more lines to this, but this is the general idea, I would like to
move to the right and skip a line and move down to the next empty cell, or
exit.
 
Why do you need to move to the cell? Selections are usually NOT necessary or
desirable. You do not even need to goto the sheet involved.
with sheets("yoursheet")
range("a1")="hi"
range("b1")=1*23
'etc.
end with
 
Back
Top