469,613 Members | 1,444 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,613 developers. It's quick & easy.

excel formatting & user defined functions

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!
Sep 18 '06 #1
0 1383

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

13 posts views Thread by Allison Bailey | last post: by
5 posts views Thread by Guy Incognito | last post: by
1 post views Thread by Steven Stewart | last post: by
3 posts views Thread by Mike Caputo | last post: by
reply views Thread by dt | last post: by
reply views Thread by gheharukoh7 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.