Hi everyone,
This is my first time on here so have patience lol.
I have a problem where I have a userform to input data into sheet 2. I am having trouble making it paste in the next row. If I only have data in collum B and then I submit the form again to put data in collum A it overwrites the data in collum B instead of going to the next completely empty row.
Here is my current code I have been trying to work with.
Please Login or Register to view this content.
Last edited by cneff; 11-09-2011 at 02:18 AM.
Hi cneff
Is Column B populated and is Column A NOT populated? Without seeing your data it's difficult to recommend but try this for Next RowPlease Login or Register to view this content.
John
If you have issues with Code I've provided, I appreciate your feedback.
In the event Code provided resolves your issue, please mark your Thread as SOLVED.
If you're satisfied by any members response to your issue please use the star icon at the lower left of their post.
solution same as one already posted....
Thanks for getting back so quick.
It came back with
Run-time error '91':
Object variable or With block variable not set
further to your previous response -
yes Column B is sometimes populated where Column A is not. sometimes It could be column C or D ect with combinations also
Hi cneff
Put this code in a separate general module.Does it return the Row you're looking for?Please Login or Register to view this content.
Hi John,
I know this may sound silly but what and where is a separate general module
I ran it in a separate module but it came up with the same error
Hi cneff
Open your workbook and enable macros. Open VBA (Alt + F11). VBA will open. In the Menu Bar (top of the screen) select Insert-->Module. That will open a window on the right hand side of the screen. Copy this codePaste the code in the right hand screen. Make certain "Option Explicit" doesn't appear twice...if it does delete one of the occurrences of "Option Explicit".Please Login or Register to view this content.
Put your cursor on this line of codeNow, step through the code (click on "F8" key)...as you click "F8" each line of code will execute. Let me know what the message box says.Please Login or Register to view this content.
It came up with the same error as before
Run-time error '91':
Object variable or With block variable not set
after hitting F8 on
NextRow = Cells.Find("*", Cells(Rows.Count, Columns.Count), SearchOrder:=xlByRows, _
SearchDirection:=xlPrevious).Offset(1, 0).Row
Hi cneff
Sorry...you were posting as I was composing. If you're still getting the error message then I need to see your file (with code) so I can "see" what's going on.
I have attached the workbook.
I havent finished the macro for all the form yet but It will all fall into place once it can submit to the next completely empty row
Hi cneff
Don't pretend to know what you're trying to do...this code change appears to add data to the next available rowLet me know what's not working as you require.Please Login or Register to view this content.
Hi John,
Thanks it works a treat.
I really appreciate your help
Hi cneff
You're welcome...glad I could be of help. If that satisfies your need, I'd appreciate it if you'll please mark your thread as "Solved".
To mark your thread solved do the following:
- Go to your first post on the thread
- Click edit
- Click Advance
- Just below the word "Title:" you will see a dropdown with the word No prefix.
- Change to Solved
- Click Save
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks