Post Values in the next row

[bren1]

Hi,

I'm not that clued up on VBA or macros but I do have a few i regularly use, I’ve found a thread related to my problem but cant make much sense of it.

Basically i want to post the 3 cell values (C5,C7,C9) into row B20,C20 and D20 respectively. However I want these values to form a list staring with row 20 and working down onto the next available/empty row.

Wondered if anyone had done this/shed any light on the area,

Many Thanks,

[Leith Ross]

Hello Bren1,

Did you want this happen once the cells' contents change or did you want to use a button on the worksheet to run the macro? Will all 3 cells always have data in them when posted or are blanks allowed?

Sincerely,
Leith Ross

[bren1]

Sorry, yes ill would like to use a button the user will update the cells then post them into their destination in the next empty row. No blanks will be allowed but the users will know this so its not that important

Thanks,

Brendan

[bren1]

Anyone got any ideas/need more information?

[SOS]

Hi bren1,

Perhaps something like this might help:

Please Login or Register  to view this content.

[bren1]

Hi Seamus,

Thanks for the response I gave that code a try but received the error:

"Run Time Error '91': Object variable or With Block variable not set"

Any thoughts?

Thanks,

Brendan

[royUK]

Check out the ContactsForm example here

http://www.excel-it.com/vba_examples.htm

[Rubeus_Hagrid]

Hi,

Please see if this helps.

Please Login or Register  to view this content.

[royUK]

SOS's code should work if amended to this

Option Explicit

Please Login or Register  to view this content.

[bren1]

Thanks for all your much needed help guys; It's working now.