Hide/Unhide a row in Excel

M

Mohanasundaram

Hi All,

I would like to hide or unhide a row in an Excel
sheet programatically. I am not good in VBA. Please tell
me how to do that.

Thanks in advance


Regards,
Mohan.
 
D

Dave Lett

Hi Mohan,

If you're new, then you can use the macro recorder to learn how to do this:

Selection.EntireRow.Hidden = False

If you know the row that you want to hide (and it isn't the selection), then
you can use something like the following:

ActiveSheet.Rows(1).Hidden = True

HTH
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Unhide sheet 2
peculiar condition: form optionbuttons lose position and linkedcellon row hide 1
Repeating a row other than the 1st row as the header row in a table from next page 1
Unhide a row 1
How do I unhide a row when ENTER is pressed in a certain cell? 6
Update several ppt documents from a single excel file 0
Need Help with a VBA subroutine 0
Hiding/Unhiding Rows Automatically 1

Top