Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Submit new data
Hello group, I guess this could be very simple but I need some help, I
created a userform that will ask the user for some information and then all this information should be submitted and written to a sheet , how do I make a macro to determine where is the last row with information so the new data is placed in the next row ? thanks to all and sorry for my english.. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Submit new data
Use something like this to find the next row, will go to the next blank cell
in column A Range("A65536").End(xlUp).Offset(1, 0).Select -- Paul B Always backup your data before trying something new Please post any response to the newsgroups so others can benefit from it Feedback on answers is always appreciated! Using Excel 97 & 2000 ** remove news from my email address to reply by email ** "msnews.microsoft.com" wrote in message ... Hello group, I guess this could be very simple but I need some help, I created a userform that will ask the user for some information and then all this information should be submitted and written to a sheet , how do I make a macro to determine where is the last row with information so the new data is placed in the next row ? thanks to all and sorry for my english.. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Submit Button | Excel Discussion (Misc queries) | |||
Clear a set of combo boxes after a Submit of data to a new sheet. | Excel Worksheet Functions | |||
Submit Button? | Excel Discussion (Misc queries) | |||
Submit Button | Excel Worksheet Functions | |||
I wanta infopath form to submit data to an excel databse file | Excel Discussion (Misc queries) |