Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Called subs versus functions
I'm relatively new to VB and Excel.
Below is an example of a 'utility sub' that I use. (vars are dim'ed in declarations section.) The mso HELP does not help efficiency or other factors concerning choosing a sub or a function for code like this, or perhaps with some 'more' processing. What advice do you have? Thanks. Sub zHide_rowrange(fromrow, torow) first = fromrow last = torow hiderange = first & ":" & last Rows(hiderange).Select Selection.EntireRow.Hidden = True End Sub -- Neal Z |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Common Functions and Subs | Excel Discussion (Misc queries) | |||
Calling VBA add-in functions/subs from another Excel file. | Excel Programming | |||
General Question regarding passing cells, ranges, cell values through subs & functions | Excel Programming | |||
how to make subs/procs can only be called from within the workbook they belong to? | Excel Programming |