Set statement

aftamath77 · Oct 6, 2008

Dim intHXRCount As Integer
Set intHXRCount = Worksheets("Sheet8").Range("G4").Value

I get an error that says "Object Required"

aftamath77 · Oct 6, 2008

aftamath77 said:
Dim intHXRCount As Integer
Set intHXRCount = Worksheets("Sheet8").Range("G4").Value

I get an error that says "Object Required"

TomPl · Oct 6, 2008

Skip the "Set". Code should read:

Dim intHXRCount As Integer
intHXRCount = Worksheets("Sheet8").Range("G4").Value

Tom