Hide/Unhide cells using VBA programming

G

Guest

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.
 
G

Guest

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?
 
G

Guest

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

Guest

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

Hide / Unhide each row from StartRow to LastRow for multiple conditions 6
Question on Hide/Unhide cells 4
Hide unhide non-contiguous columns 6
peculiar condition: form optionbuttons lose position and linkedcellon row hide 1
Disable/enable or lock/unlock cells in VBA dependent on other cells values 2
Hide, unhide macro 19
VB Code to hide rows 3
Hide and Unhide 3

Top