Method 'Range' of object '_Global' failed

[davidman1]

Hi

I've made a macro to add a new absence to the bottom of a spreadsheet but I get the error code in the title at the line in bold. My code is

Please Login or Register  to view this content.

Any ideas? I've tried bypassing the New_EE_Id variables but it still doesn't work (it also makes it harder for anyone following me to look at it and understand it which makes me want to keep it in).

[AB33]

Please Login or Register  to view this content.

[AB33]

Please Login or Register  to view this content.

[davidman1]

Thanks, but this highlights ".Rows" and says "Invalid or Unqualified reference", if I move the "End With" to the end of the sub then it says "Object variable or With block variable not set"

[AB33]

Yes, that is right, but look at the full code I had amended.

[Norie]

Try this.

Please Login or Register  to view this content.

[davidman1]

Yes, that is right, but look at the full code I had amended.

This gives LastRow + 1 = 11 (which is right) - I need New_EE_Id to go be cell A11.

[davidman1]

Try this.

Please Login or Register  to view this content.

Thanks, this is just what I need :D