Range.("a4").select not working

PROJECT: Workorder Database

I'm trying to write some code for a simple database and am needing some of your VALUABLE help. I know very little about VBA and will be learning this as I go, please be patient.

I'd really like to do this in 'baby steps'. Thanks

I've formatted a spreadsheet for the data to be collected, it looks like a form.
Just some cells with data, i.e. name, address... (actually several sheets of data)

I want to take the data from the form and have a button append it to the next empty row of a different sheet (this sheet will be in a different file eventually).

I think I'll be using some type of automated copy/paste from there (somewhat done, it did work, now doesn't).

Please remember 'baby steps'.

If someone already has some code that would be fine, if not then...



Here's some code I wrote,

The button was on the 'database' sheet and worked well(?).
When I cut and pasted the button to my 'form' it stopped working.

It is giving me an error at 'Go to DB and Selects first empty row' selecting cell a4. I tried skipping that line, it gives me an error on all 'range' lines. I tried the 'activate sheet' but still does not work.


THANKS IN ADVANCE, Phil

Please Login or Register  to view this content.

History

12/03/07
....what statement is used to select the next empty row?

I've tried the 'end(xldown)' it gives me the last used row.

.......Used 'activecell.offset' THANKS to marcos

I think your code can be simplified a little:

Please Login or Register  to view this content.

I copied your

Please Login or Register  to view this content.

Over my

Please Login or Register  to view this content.

Still giving me a 'runtime' error at that spot.


I'm thinking it has to do with the button being on a different sheet and the other sheet needs to be activated, but I tried that and it still won't work...

I like the idea of combining the commands, THANKS.