Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
so i have some information in blocks, in a selection i want to find the
first cell with the name "Elder" in it then move down 2 rows and check if this cell has "Elder" also, if the cell (after offset) doesn't have "Elder" in it then i want to save the cell as an Object to display in a ListBox later in the program. my problem is when i try to do the If(j.Offset (2, 0) < "Elder" Then... a Run-time error '13 Type mismatch. pops up. is this type mismatch saying that i cant do the .Offset on a variable that comes from a (Set j = ..Find("Elder",,,,xlByColumns)) command earlier in the script? do i have to somehow change this variable (j) to a different type before i can do a .Offset command on it? thanks for any and all suggestions |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Find, Copy offset to offset on other sheet, Run-time 1004. | Excel Programming | |||
getting vba shell command to execute batch and save output to a file | Excel Programming | |||
Excel has a "Find Next" command but no "Find Previous" command. | Excel Discussion (Misc queries) | |||
Write Command Output | Excel Programming | |||
Write Command Output | Excel Programming |