refering to range... 1

johnny45 · Dec 30, 2007

Why is this not working ?

Code:

Sub customershow()
If Sheet1.Range(.[a1]).value = "" Then
Customers.Show
Else
Customer.Show
End If
End Sub

SkipVought · Dec 30, 2007

Hi,

Code:

Sub customershow()
If Sheet1.Range("a1").value = "" Then
Customers.Show
Else
Customer.Show
End If
End Sub

or

Code:

Sub customershow()
If Sheet1.[a1].value = "" Then
Customers.Show
Else
Customer.Show
End If
End Sub

Skip,
_{When a diminutive clarvoyant had disappeared from detention, headlines read...

Small Medium at Large}

johnny45 · Dec 30, 2007

Thanks Skip !

Cheers and the Very Best for the New Year !