Set statement

  • Thread starter Thread starter aftamath77
  • Start date Start date
A

aftamath77

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

I get an error that says "Object Required"
 
aftamath77 said:
Dim intHXRCount As Integer
Set intHXRCount = Worksheets("Sheet8").Range("G4").Value

I get an error that says "Object Required"
Click to expand...
 
Skip the "Set". Code should read:

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

Tom
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel to word macro 1
Copy a range data from 1 sheet to multiple selected sheets 1
Still need help - Clear a cell upon workbook Close 2
Still need help - Clear a cell's contents when document is closed 7
Why is this code not working ? 3
Excel VBA 1
Combining macros 9
variable sheet name 6

Back
Top