Computer Problems? Computing.Net has over 1,000,000 posts about all things technology related! Over 90% answered within 24 hours! Click here to start participating now! Also, be sure to check out the New User Guide.
auto adding a row
Name: alpha314 Date: December 8, 2004 at 15:45:20 Pacific OS: Win2000 pro CPU/Ram: P4-1.0/256
Comment:
I make a data form with 50 rows for entering 50 differents data in MS Excel. Now my question is -- is there any way I can setup form to automatically add new row or more row when we use last row ?
Name: andyhargreaves Date: December 9, 2004 at 07:45:25 Pacific
Reply:
I'm not sure, but what I think you mean is to add the formulae etc into a new row below the one it is currently in.
This could be achieved with a macro, but would not be automatic. You would have to tell users to press a button (assigned to the macro) once they've filled in the last row.
I'm sure someone would come up with a better solution!
Summary: I got it figured out. It was not recognizing the "date" as a valid progression. I added another row I titled week # and ran it 1-52 reffenced that instead of the date and it worked fine. thanks for ...
Summary: I want to sample a cell in Excel and if it is empty, I want to delete that row. I can delete a row using the row number but can't do it using a variable. Example.. for row = 1 to 5 if activeheet....
Summary: I need a macro that will identify if a value is entered into a specific cell, then that whole row needs to be copied. Ie: if F2 contains data, insert line and copy row two. I found the following m...
0 
Outlook97 Send Problem
