Results 1 to 3 of 3

Range as Parameter in Function Declaration

Threaded View

  1. #1
    Registered User
    Join Date
    07-27-2009
    Location
    Chicago, IL
    MS-Off Ver
    Excel 2003
    Posts
    13

    Range as Parameter in Function Declaration

    A simple question that google yields no assistance on.

    I have a formula that hides rows within a range for a sheet.

    Sub HideRows(RStart As Range, REnd As Range)
       Range(RStart, REnd).Select
       'Code to Hide Rows, does not matter
       ...
    End Sub

    I am clearly doing something wrong because I am having troubling calling the function.

    For instance Call HideRows("A1", "A20) does not work

    Also, changing the HideRows formula to have one parameter does not work for me

    Sub HideRows(RStart As Range)
       Range(RStart).Select
       'Code to Hide Rows, does not matter
       ...
    End Sub
    
    Call HideRows("A1:A20")
    Any guidance would be appreciated as I am not sure how to use parameters
    Last edited by Hot Soup; 08-06-2009 at 02:10 PM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1