Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Can anyone tell me why this produces Run-time error 13: Type mismatch?
Thanks in advance. ---------- Option Explicit Private Sub testloop() Dim lstrow As Long Dim i As Long Dim agtname As String lstrow = Range("a" & Rows.Count).End(xlUp).Rows For i = 2 To lstrow agtname = Range("a" & i).Value ' *** also tried .Text & still got error MsgBox "Current Name is " & agtname i = i + 1 Next i End Sub |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Type mismatch... | Excel Discussion (Misc queries) | |||
Type mismatch | Excel Programming | |||
Type Mismatch | Excel Programming | |||
Type mismatch | Excel Programming | |||
Type Mismatch | Excel Programming |