Find next blank row even if there is a formula in that row

**dlhslim** · 06-10-2011, 06:33 AM

I have coded a userform that enters data into the next available blank row but if there is a formula in that row then it wont enter it in that row, I would like to add data to rows that also contain formulas that produce a blank result. Here is the current code that I am using:

Please Login or Register  to view this content.

Thankyou in advance.
Deb.

**Domski** · 06-10-2011, 06:49 AM

Maybe:

Please Login or Register  to view this content.

Dom

**dlhslim** · 06-10-2011, 07:01 AM

Hi Dom,
Thanks for your code, however it still entered the data into the next row that didn't contain a formula, but I want it to add it to the next row that does contain a formula. The formula is in Column A & my data is entered into Columns B & onwards.

**Domski** · 06-10-2011, 07:21 AM

Rather than checking column A for the last row can you not check B then?

Please Login or Register  to view this content.

Dom

**dlhslim** · 06-10-2011, 08:35 AM

Thanks Dom, this worked perfectly, only change I had to make to this code of yours was to add a new line from .End & an underscore after the cells, see eg. below:

Originally Posted by Domski

Rather than checking column A for the last row can you not check B then?

Please Login or Register  to view this content.

Dom

**Domski** · 06-10-2011, 08:55 AM

No worries.

I assume you know that isn't an integral part of the code, just a method of spreading long lines of code onto more than one line to make them easier to read?

Dom