View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Charlie Charlie is offline
external usenet poster
 
Posts: 703
Default Hide/Unhide cells using VBA programming

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.