Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
type mismatch
i get a type mismatch error in the following line; rw2 =
Sheets("NI").Range("A9").End(xlDown) + 1 any ideas? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
type mismatch
I bet you want the row number:
rw2 = Sheets("NI").Range("A9").End(xlDown).row + 1 If you leave off .row, then excel assumes you want the .value (and who knows what that might be). John wrote: i get a type mismatch error in the following line; rw2 = Sheets("NI").Range("A9").End(xlDown) + 1 any ideas? -- Dave Peterson |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
type mismatch
thanks dave
"Dave Peterson" wrote: I bet you want the row number: rw2 = Sheets("NI").Range("A9").End(xlDown).row + 1 If you leave off .row, then excel assumes you want the .value (and who knows what that might be). John wrote: i get a type mismatch error in the following line; rw2 = Sheets("NI").Range("A9").End(xlDown) + 1 any ideas? -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Type Mismatch | Excel Programming | |||
type mismatch here! | Excel Programming | |||
Type mismatch | Excel Programming | |||
Type mismatch | Excel Programming | |||
Type Mismatch | Excel Programming |