look for blank cell Above starting cell instead of below

**stuartglass** · 12-15-2010, 02:53 PM

Hi there, I have a macro that determines the starting cell in a column, and if that cell is not blank, it will find the first blank cell below it. I want it to also find the first blank cell above it._Here is what I have so far:

Please Login or Register  to view this content.

I then have similar coding underneath but instead of xlDown, using xlUp, but rather than finding the first blank cell above the start point, it goes straight to the top of the column.
Is there either a quick fix, or a totally different way of doing it, eg a loop of, is cell blank yes/no, if no look at cell above and try again. if no blanks cells above then return "none found"
Much appreciated

**stuartglass** · 12-16-2010, 06:29 PM

still no reply, ive have now dusted off my vba book and come up with this alternative, but this literally does nothing, but has no bugs.

Please Login or Register  to view this content.

please help

**shg** · 12-16-2010, 06:36 PM

Would you explain what the value in D6 might be, and what you would expect to find?

**stuartglass** · 12-18-2010, 09:08 AM

the value in D6 is B15, but it changes based on where the starting value is supposed to be.
basically its a diary booking system. the Value in D6 matches the time slot in the diary that you want to try and book too. If that time is not available, ie if that cell in the diary is not blank, then it looks before and after to find the nearest available time.

**stuartglass** · 12-21-2010, 06:58 AM

Eventually working it out myself, after about the 4th total rewrite. In case anyone is interested here it is.

Please Login or Register  to view this content.

Now that I've sorted that out, I now need to work out how to make it find the NEXT slot, if the one it thows up as the first available is not suitable for the customer and they were prefer a later/earlier etc time. So I may be back soon.

**stuartglass** · 12-21-2010, 07:25 AM

dang its not working. The "Do Until" Loops are not doing what they should. They are not looping until the first blank cell, they are only looping once. I know this because when the starting cell is not blank and the one after it is not blank either, it is telling me that time, the one after the start, rather than continuing to look.

please help.