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.

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?

"Thulasiram" wrote:

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.

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

"Charlie" wrote:

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?

"Thulasiram" wrote:

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.

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.

"Thulasiram" wrote:

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

"Charlie" wrote:

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?

"Thulasiram" wrote:

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.