VBA to increment number not working

[wonderdunder]

I'm using a userform to enter data and to insert the data into a sheet as a row. the values in row A are record numbers that increment by 1 each time a row is entered.

The problem is that while it inserts the new row with the data, the record number only comes in as 1 and I'm banging my head against a brick wall trying to solve it. Cells in row A are formatted as number.

here's the code (there are more columns but they are not needed to be shown). Hope someone can help / put me out of my misery!

Please Login or Register  to view this content.

[Bob Phillips]

Should this line

Please Login or Register  to view this content.

be

Please Login or Register  to view this content.

[sweep]

Hi,

Could you please edit your post and wrap the code in code tags?

Then, remove the dot from in front of Newrow in the 4th line of code.

[wonderdunder]

Hi, it is without the full stop as in the second part quoted (don't know how that got in there). Sorry for that

[wonderdunder]

Tried a little problem solving and I know that this:

Please Login or Register  to view this content.

is the problem. I've got it to print in another cell the value without +1 and it comes up as null. All other steps check out OK.

I've double checked the cell formatting and it is definitely set up as number (0 dp). I've also entered in another cell "=A2+1" and it shows the correct result.

So for some reason the code I've just referred to is not seeing the value held in the cell above (and it definitely does look at it). I thought it might be the way it is entered so I have manually typed in some values but its still not working. Any ideas why?

[Bob Phillips]

Please Login or Register  to view this content.

[wonderdunder]

That's got it going - thank you!