Ok so i have been trying to figure this out for weeks now and i am desperate. I need to be able to configure the userform that is attached to the button you will see under the RESCHEDULES section named ADD R/S. I need to be able to have the userform look for the next blank row and insert the data only between the rows B37:B67. I cannot only use a column as it needs to stay within this specific range. Is this even possible? i have attached the sample sheet for you thanks in advance!!
Last edited by KBYERS; 07-16-2023 at 09:45 PM.
There is no code in this file. The button runs a macro in another file that you did not provide.
Maybe this will help:
Please Login or Register to view this content.
sorry about that i attached the correct one to the original post
no that doesnt work i just get the message that no more blank rows in that range?? Every one of the rows in that range are blank i am so confused
OK bug in my code forgot about the case where they are all blank. Hang on.
You didn't say where in the code this is. The only place I can find that looks for a row is in CommandButton1_Click. I have modified your code with a correction. But I don't know how to use your file so I ran a test in my file, but not yours.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks