Range entering with set DIM

Hi folks

I have the following code...

Please Login or Register  to view this content.

I've set the rRange values as i dont want to keep typing it in, as there are a few checkboxes to go through. however when the code runs it overtypes everything in the first row.

I thought using the END(XLUP).OFFSET part would do what it normally does, but the range set seems to be ignoring this.

Any ideas???

Thanks

Do you have a Table on the worksheet?

ROMPERSTOMPER - there is an empty table in the worksheet that i'm trying to enter the information into.

WALRUSEGGMAN - That code unfortunately didnt work

Thanks

How big is the table? Using End(xlUp) behaves differently with tables. Ideally your table should only have one blank row for entering data and you then add rows to it as needed.

Sorry Romper - its not a table, just a standard worksheet!

That's right

The first empty cell is E7, then the next results need to go E8, E9, E10 etc.

So...

I have two checkboxes in the userform (there will be more!) and when both are ticked i want two lots of information to be input...

E F
row1 = Input1 Input2
row2 = Input3 Input4

Instead of putting 'input3' and 'input4' into row2 its 'overtyping' it into row1, over the information thats already there.

Hope that makes sense?

thanks

You need to recalculate rRange1 and rRange2 each time you add data to the worksheet.