Simple - Set range as first empty row in range

[Pergo]

Hi All,

I have a real simple one that I think I'm making harder than it really is.

I have a sheet where I have several shared users using a userform to enter data.
To prevent them overwriting each other, I want to give each username a range. John is rows 3-22, Mike is rows 23-42, Mary is rows 43-62..
Then I want it to find the first empty row within that range
For instance:

Please Login or Register  to view this content.

The only thing I'm missing is how to specify the row to start on. The above code just finds an empty row, what do I add to make john start at row 3?

Thanks!

[JBeaucaire]

Here's a way assuming you don't allow blanks to occur within the range:

Please Login or Register  to view this content.

[Pergo]

Thanks!

How would you write to the cells based off of that?

When I do

Please Login or Register  to view this content.

I get Application-defined or object-defined error.

[JBeaucaire]

When you DEBUG and it highlights that line of code, hover your mouse over NR.... what is the value?

This just worked perfectly for me:

Please Login or Register  to view this content.

[Pergo]

I copied your code but it doesn't change anything. The macro executes fine but it doesn't change any cell to "test".

[Pergo]

How about this:

Please Login or Register  to view this content.

The only problem with this is the 'Cells' line gives me the application/object-defined error.

[JBeaucaire]

I'm going to guess what you're describing as "empty" may not really be. I would certainly test the suggestions I've given in your workbook, if you wish. Click GO ADVANCED and use the paperclip icon to post up a copy of your workbook.

[Pergo]

I deleted all cells and ran it again. It worked. Except, it doesn't move down the range. I'd like if the macro is ran subsequent times, to goto the next 'empty' cell in that range.

I attached a file with both codes in it.

I appreciate all your help!

[JBeaucaire]

Well poo, the SpecialCells method only works if there is something nearby to indicate non-blanks....me just being dumb. This seems to do what you want:

Please Login or Register  to view this content.