Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
The code below works but I want to substitute the variables (RR_Count &
CC_Count) for the literals (25,0). I can confirm the correct numeric values being obtained by the variables. Yet, as soon as I substitute the variables, I get an error 13 - type mismatch. The values are always numerics and are intended as displacement values for use by the offset. I am still very new to VBA and may be missing something obvious. I tried DIM RR_Count as Integer but that gave me a different error. Thanks for any thoughts or suggestions... ================================================== ==== ' ' Fill Output Detail Fields ' For BB = 0 To 15 Step 1 ' ' RR holds the ROW ID from the selected record in Table_Input RR_Count = Range("Table_Input").Offset(BB, 2).Value ' ' CC holds the COLUMN ID from the selected record in Table_Input CC_Count = Range("Table_Input").Offset(BB, 3).Value ' ' Range("K1").Offset(25, 0).Value = Range("Table_Input").Offset(BB, 5).Value ' ' ' Next BB |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Run-time error '13': Type mismatch | Excel Programming | |||
Run time error 13, type mismatch | Excel Programming | |||
Run Time error 13 type mismatch | Excel Programming | |||
run time error 13 type mismatch | Excel Programming | |||
Run-Time error, type Mismatch | Excel Programming |