HELP WITH VBA!!!!

[MIKEREED]

I have been trying to create a macro in excel VBA which will capture the contents of a cell at a certain time before the off and paste it to sheet 3 but each time its captured from a race i don't want it to paste in the same cell so i can build up a kind of history. I am a newbie VBA user.
Very Confused 2003 Excel user!!!:?

[phrenetic]

You just need to create a variable to hold the current row and then increment it by one before writing out the copied value.

If you post up what you have already, I'm sure we can tweak it for you.

Alistair

[MIKEREED]

Thanks for the reply Alistair.I have absolutely no knowledge of vba and having looked at other posts the more I see the more confused I become.Any help or pointers would be much appreciated.
Mike

[Captain Sensible]

Something like

Worksheets("Sheet3").Range("A65536").End(xlUp).Offset(1, 0).Value = Worksheets("Sheet1").Range("A1").Value

Would copy the contents of cell A1 from sheet1 to Sheet3 starting at A1 and keep adding data to A2 A3 etc

[MIKEREED]

Thanks for your help guys.I'll give it a go but i maybe back in touch lol.