LinkBack URL
About LinkBacks
"Object variable or With block variable not set (Error 91)" is the error i get on the last line of code.
Please Login or Register to view this content.
"Object variable or With block variable not set (Error 91)" is the error i get on the last line of code.Please Login or Register to view this content.
Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.
Remember to desensitize the data.
Click on GO ADVANCED and use the paperclip icon to open the upload window.
View Pic
Cheers!
Deep Dave
Maybe:
Please Login or Register to view this content.
test1.xlsm
What I need is a value for the row where the value from the dropdown list is found on the Y sheet, and a value for the column in the X sheet.
Doesnt work John, sry.
Maybe:
Please Login or Register to view this content.
That is happening because you have merged cells.
If you change to this line, it will work
Set rngsearch2 = st2.Range("c19:C21")
I'm trying something, will comeback with a reply.
Last edited by a.hudrea; 09-04-2015 at 08:19 AM.
Umm. Worked for me on the sample you provided. Msgbox with 4 then a msgbox with 8. Note changes too code to be made.
Please Login or Register to view this content.
Sorry for the late reply. It does work John ty so much guys for the help. I did not notice the resize part.
You're welcome. Glad to help out and thanks for the feedback.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks