Hi,
I have got this code which I took from the same title posted earlier. It works fine when the code is run independently but when merged with some other codes, it gives an error message "Run-time error '91': Object variable or With block variable not set". The code is:
Is the error because of conflict of some declaration. The variables declaration is Ok. Can somebody come up with the solution, please?
Please Login or Register to view this content.
Roshan Shakya
Last edited by Roshan.Shakya; 07-05-2019 at 11:32 AM. Reason: Inserting tags
Sounds like Sheet1 is empty.
Also please edit your post to include tags, the # icon in the reply/edit window
Sheet1 has data which is dynamic and keeps on changing. Sheet2 already has data that cannot be overwritten and in fact the Sheet1 data has to copy pasted every time interval. The problem is that the copied data from Sheet1 should be pasted in destination Sheet2 after next to last row.
By the way, I have been able to use the sub procedure (that works independently) by using the Call function. I would definitely appreciate solutions for the error.
With regards
Roshan Shakya
What line produces the error?
Earlier the following line produced the error, but to my amaze, I am not getting that error now. I am bemused.
ThanksPlease Login or Register to view this content.
Roshan Shakya
Last edited by Roshan.Shakya; 07-05-2019 at 11:53 AM. Reason: for correction
Glad it's sorted & thanks for the feedback
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks