Hide/Unhide cells using VBA programming

T

Thulasiram

Hello,

I would like to know the VBA code that should written in the commnad button
(Hide/Unhide) placed in the Excel worksheet to hide/unhide the cells that are
"empty". i.e, if the cell is empty and hide button is clicked, then the empty
cells have to be hidden. and if the cell is with by any alphanumerical
character, then that cell should not be hidden when hide button is clicked.
 
C

Charlie

Can't hide individual cells. You can hide entire columns or entire rows.
Are you trying to hide one row, one column, all empty columns, what?
 
T

Thulasiram

Yes. You got it right. I would like to hide all empty columns and all empty
rows. Please help me regarding this.
 
T

Thulasiram

Charlie,

Also, if you could suggest any good reference where I could get ample
information for my questions like this, it would be great.

Thanks,
Thulasiram.
 

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

peculiar condition: form optionbuttons lose position and linkedcellon row hide 1
Question on Hide/Unhide cells 4
Hide and Unhide 0
form buttons on sheet collapse on unhide - sometimes 5
Hide unhide non-contiguous columns 6
Hide, unhide macro 19
Test for value and hide or unhide based on result 0
Create form with checkbox les that expand and collapse sections of the form? 0

Top