Logo 
Search:

MS Office Forum

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds

How to choose the whole column/row of the active cell?

  Asked By: Arland    Date: Aug 22    Category: MS Office    Views: 840
  

I tried to record it but it doesn't work. What is the code to select
the whole column/row of an active cell? In excel, Shift+Space, Or,
Ctrl+Space, will work. But I don't know what is the code for it.

Share: 

 

2 Answers Found

 
Answer #1    Answered By: Lurleen Fischer     Answered On: Aug 22

Try these:

Selection.EntireRow.Select

Selection.EntireColumn.Select

 
Answer #2    Answered By: Helina Bonkob     Answered On: Aug 22

If it's the active  cell's row you're after, the code  is
activecell.entirerow.select

If it's the column you want, it's activecell.entirecolumn.select

 
Didn't find what you were looking for? Find more on How to choose the whole column/row of the active cell? Or get search suggestion and latest updates.




Tagged: