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...

Erm nm...

I figured it out...


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