Logo 
Search:

MS Office Answers

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds
  Question Asked By: Brooklyn Smith   on Nov 05 In MS Office Category.

  
Question Answered By: Brian Ross   on Nov 05

The Range goes to the last cell in the first column ,A65536, and then goes to the top, A1. The Offset part of your code then takes you to the second row  first column.


Range("A1”).Offset(1, 0).Select would do the same thing.


Selection.Offset(1, 0) would take you to the cell below the current cell

And

Selection.Offset(0,1) would take you to the cell to the right of the current cell.

Share: 

 

This Question has 12 more answer(s). View Complete Question Thread

 
Didn't find what you were looking for? Find more on How to decipher next row? Or get search suggestion and latest updates.


Tagged: