| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
"Select method of Range class failed" Error
I am getting this error message in my code but the code ha being working
perfectly well before with no issues or errors. The error occurs on this line: "Sheets("Site Lists").Range("V" & rwNum).Select" I tried "Worksheets("Site Lists").Range("V" & rwNum).Select" and got the same error. Any ideas? For Each c In Worksheets("Sites Table").Range("B2:B" & totalSiteCount).Cells If c.Value < "" And IsDate(c.Offset(0, 9).Value) Then Worksheets("Site Lists").Range("U" & rwNum).Value = siteNum Worksheets("Site Lists").Range("V" & rwNum).Value = c.Value Worksheets("Site Lists").Range("W" & rwNum).Value = Mid(c.Offset(0, 2).Value, 5) Sheets("Site Lists").Range("V" & rwNum).Select Selection.Interior.ColorIndex = 6 rwNum = rwNum + 1 siteNum = siteNum + 1 End If Next c |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Autofill method of range class failed | Excel Discussion (Misc queries) | |||
| Autofill method of range class failed | Excel Discussion (Misc queries) | |||
| Runtime 1004 error -- insert method of range class failed. | Excel Discussion (Misc queries) | |||
| Run-Time error '1004' : Select method of Range class failed | Excel Discussion (Misc queries) | |||
| Run-time error "1004" Select method of range class failed | Excel Discussion (Misc queries) | |||
Threaded Mode
