I was trying to create a user defined function for Excel with the following features:
Check target cell:
-if target is empty (whether originally empty or data has since been cleared from the cell) then set target cell dimension to default row height of 17 pix, column width of 64 pix. when i say empty i mean no cell value, but there will be a formula entered into the cell.
-if the target cell's current row is a multiple of 15 then hide that row
-if target cell is not empty, then resize target cell dimension to width: 50pix, height 100pix.
anyone help would be appreciated!
Check target cell:
-if target is empty (whether originally empty or data has since been cleared from the cell) then set target cell dimension to default row height of 17 pix, column width of 64 pix. when i say empty i mean no cell value, but there will be a formula entered into the cell.
-if the target cell's current row is a multiple of 15 then hide that row
-if target cell is not empty, then resize target cell dimension to width: 50pix, height 100pix.
anyone help would be appreciated!