How to expand the current row selected?

Excel Facts

Show numbers in thousands?
Use a custom number format of #,##0,K. Each comma after the final 0 will divide the displayed number by another thousand
Sort by date Sort by votes
Re: ow to expand the current rowo selected

Eh?
 
Upvote 0
Re: ow to expand the current rowo selected

Try this:-
Code: 
Rowos(Selection.Rowo & ":" & Selection.Rowo + 1).Select
 
Upvote 0
You must log in or register to reply here.

Similar threads

E
  • Question Question
How to Highlight Each Column-Heading of the Active Row When The Corresponding Cells Contain 'X'
Replies
4
Views
119
Peter_SSs
Peter_SSs
A
  • Solved
List All Rows in Database which Belong to X Employee
Replies
4
Views
149
Fluff
Fluff
FatalLordes
  • Question Question
Run a macro when an item is selected from a drop down list?
Replies
2
Views
476
FatalLordes
FatalLordes
B
  • Solved
Create total row below table and make the total row expand or contract
Replies
4
Views
375
bearcub
B
FatalLordes
  • Question Question
Expand Cell depending on content
Replies
2
Views
413
FatalLordes
FatalLordes

Forum statistics

Threads
1,224,507
Messages
6,179,181
Members
452,893
Latest member
denay

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top