Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2004
    Posts
    2

    Arrow Unanswered: Function(variable)...

    Hello,

    Just wondering if theres w different way of doing this because it doesn't work . I want to be able to specify the sheet to look at but this doesn't work... I get the error: "Runtime Error 424 - Object required"...

    In VBA:
    ===========================================
    Private Function CheckCells(sheet_name) As Worksheet

    sheet_name.Range("A1")

    ' #####################
    ' (Rest of code goes around here)
    ' #####################
    End Function

    Private Function Dave()

    CheckCells ("Sheet1")

    ' #####################
    ' (Rest of code goes around here)
    ' #####################
    End Function
    ===========================================

    Any ideas?! - I'm a bit new to this...

  2. #2
    Join Date
    Mar 2004
    Posts
    2
    Erm nm...

    I figured it out...


    Sheets(sheet_name).Range("A" & cell_count)

Posting Permissions

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