Finding a missing date and listing name from next Column

**mhill** · 01-27-2010, 01:28 PM

I am try to show a list of all rows that have a missing date in column "B" and then show the corrasponding name in the next column "C". I can find the first one on the sheet and how many have missing dates using:

Please Login or Register  to view this content.

But I can't figure out how to show the rest of the missing dates, either in a listbox or populate the combobox with all of the names.

**Leith Ross** · 01-27-2010, 03:55 PM

Hello mhill,

I have made a few changes to your macro. The range is now restricted from B1 to the last cell in column B with data instead of the entire column. The names are loaded into an array and the ComboBox is loaded using this array.

Please Login or Register  to view this content.

**mhill** · 01-28-2010, 10:32 AM

Hi Leith,

Thanks for taking the time to look at this.

I'm getting a Type MisMatch on:

ReDim Preserve arrNames(f)

I'm not for sure what i need to change.

Thanks,

Martin

**Leith Ross** · 01-28-2010, 02:22 PM

Hello Martin,

Sorry, my typing is less than stellar.

Please Login or Register  to view this content.

**mhill** · 01-28-2010, 03:57 PM

O-Geez, I think my reading is worse.

**mhill** · 01-28-2010, 05:41 PM

Hello Leith,

Got it working, Thanks very much for your help and time.

Martin

**mhill** · 01-28-2010, 09:57 PM

hi Leith,

I change this to show the names in a listbox and its working great.

I have one last question if you don't mind. Would it be possible to pull another cell in along with the name from the same row? I know they are going to ask for it, just wanted to get a jump on them before they ask.

Thanks,

Martin