Logo 
Search:

MS Office Answers

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds
  Question Asked By: Eva Hughes   on Nov 02 In MS Office Category.

  
Question Answered By: Brent Brown   on Nov 02

Use

ActiveCell.Row ()

ActiveCell is your current cell, and row  () is a method to return the row.

If you have an area selected, ActiveCell will be the one that is highlighted
differently.

If instead you use

Selection.Row ()

Then it returns the top row if you have a multi-row area selected.
Confirmed by help: "Returns the number  of the first row of the first area in
the range."

Share: 

 

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

 
Didn't find what you were looking for? Find more on Obtain Row and Column Information Or get search suggestion and latest updates.


Tagged: