Hiddening Rows in an embedded worksheet

W

Wendy

I am using this formuala to hide columns: Columns("by:cc").Hidden = Not
Columns("by:cc").Hidden

What formula do I use to hide a row?
I am trying to do it for rows A3:A30, and get a syntax error.
thanks
 
D

Don Guillett

Easy to tell you but better if you record the macro while doing to see the
diff..
 
W

Wendy

Hi Don,
I am very green in this area and don't understand your response. Could you
explain further what type of formuala I would use?
 
G

Gord Dibben

Wendy

Formulas cannot hide anything, only return values.

You must have some VBA code that hides the columns.

Don is suggesting you turn on the macro recorder, slect A1:A30 and Format>Hide
to see what code you get.


Gord Dibben MS Excel MVP
 

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

hidden rows, column copy-paste 0
Drop down list control value in vba 2
Hiding Columns produces error <----HELP PLEASE 2
Hide columns based on row values 2
Is row visible? 2
Shared Workbooks & Code 1
Sort partially hidden data 1
Identify Hidden Columns - New issue! 19

Top