Hi All,
This is my very first VBA project, and I'm a bit lost. I've got this run-time error:
1004 - Application-defined or object-defined error.
Could you please take a look into the program and suggest me where could the problem be?
Thank you so much:-)
Please Login or Register to view this content.
beacska
Last edited by Leith Ross; 10-28-2008 at 08:27 PM.
Welcome to the forum.
What line generates the error?
Entia non sunt multiplicanda sine necessitate
Gotta go. Try this:
Please Login or Register to view this content.
This is working perfect. :-) Thank you soo much sgh
But there is just one problem, I need to cutomise this for every different set of tables. For the one I'm working on now it should find 7 blank cells and also the rage to copy is different. I did it in this way, but now it gives me this error: "Subscript out of range"
What can be the problem?Please Login or Register to view this content.
Thanks a lot
Last edited by shg; 10-29-2008 at 09:13 AM. Reason: add code tags
I've edited your post to add Code Tags. Please read the Forum Rules before posting again.
What have you done to debug?
What line in the code gives the error, when processing what cell?
I find out... it was a stupid mistake, that the name of the sheet didn't coincided with the name defined in the code.
Thank you soooooo much for your help. :-)
I have a lot of to learn to get a little bit used to VBA...
You're welcome. My compliments on taking the initiative to modify the code yourself.
This typically means that whatever your trying to do in a specific location doesn't exist, ie: name of the sheet, cell range, workbook. I get this all the time, and almost always just a typo on my part, or forgetting to open a document I'm trying to edit.Subscript out of range
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks