View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
mathew mathew is offline
external usenet poster
 
Posts: 75
Default Run Time Error 438

This is the top part of a macro. When it gets to the

Dim rrrRng As Range
Dim lowScore As Long
Dim playerName As String

Set rrrRng = Sheet1("A2:A6")

When it gets to this line: Set rrrRng = Sheet1("A2:A6")

I get "Run Time Error 438" Any help would be appreciated.