Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Question on Hide/Unhide cells
Hello people,
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 rows/columns that are "entirely empty". i.e, if the row/column is empty and hide button is clicked, then the empty rows and columns that are entirely empty have to be hidden. I would like to hide all empty columns and all empty rows (not individual cells). Please help me regarding this. Most importantly, please suggest a good book worth buying that will deal with basics of VBA and also power programming in VBA. I would like to know all basic stuff about VBA related to hide/unhide cells, mulitply matrices, transfer contents in row/column from one worksheet to another worksheet, diagonalize the matrix, freeze/unfreeze panes, sum columns/rows and many more. This might be a question that someone would have asked before. I am new to this group and I am unable to keep track of the previous posts. Please help. Thanks, Thulasiram |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Hide/Unhide Cells | Excel Worksheet Functions | |||
Hide and unhide shaded cells | New Users to Excel | |||
Hide/Unhide cells using VBA programming | Excel Programming | |||
Switching views - Hide / Unhide preselected cells (Repost) | Excel Discussion (Misc queries) | |||
hide/unhide cells | Excel Worksheet Functions |