-
If you would like to post, please check out the MrExcel Message Board FAQ and click here to register.
If you forgot your password, you can reset your password.
with block variable
-
J
Object Variable or With block variable not set error in VBA
Hello. I am relatively new tocoding and have a problem. I have created a script that pulls data from multiple sheets into one sheet and adds the name of the original file (“Widget#”). I’m trying to copy and fill the empty cells with the file name as I will be creating a pivot table. I added...- jbuist
- Thread
- object variable error vba with block variable
- Replies: 15
- Forum: Excel Questions
-
I
Use variables in formula inserted by VBA loop
I have some code which loops through a range of cells. In each cell I want to insert a VLOOKUP formula which will look up a value relative to the active cell in another sheet. Currently I am getting an error "object variable or With Block variable not set". I am relatively inexperienced in VBA...- iaindowner
- Thread
- loop vba vlookup with block variable
- Replies: 4
- Forum: Excel Questions
-
D
Object Variable or With Block Variable not set????
Hey everyone. I'm trying to run some code but I keep getting the Object Variable or With Block Variable Not Set message. I'm not using any object in the line that is causing the error. Could someone take a look at the code and let me know what I'm doing wrong? I'm getting an error on the last...- dpiano1984
- Thread
- error 91 excel error objec variable with block variable
- Replies: 7
- Forum: Excel Questions
-
B
Code near completion, runtime error
Hello, I have a large column of UPC numbers I wish to identify. This code is designed to enter a search for UPCs at http://www.upcdatabase.com/itemform.asp. Then it copies the url of the search results page and pastes it in Excel 2007 next to its matching UPC. The end result should be a column...- bubububub
- Thread
- internet explorer loop while object variable run time error 91 with block variable
- Replies: 3
- Forum: Excel Questions
-
B
Broken Code Importing data from Internet Explorer
Hello,<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p></o:p> <o:p> </o:p> This code is designed to enter a search for UPCs at http://www.upcdatabase.com/itemform.asp. Then it copies the url of the search results page and pastes it in excel next to its matching...- bubububub
- Thread
- application internet explorer object variable run time error 91 with block variable
- Replies: 10
- Forum: Excel Questions
Some videos you may like
This Week's Hot Topics
-
Payment term and Cash flow (formula linked with costs)
- Started by Adfinance
- Replies: 43
Hi everyone, I need to calculate automatically the cash position (cashout) based on payment terms and costs. The payment terms may change, so I... -
Match to a list with wildcards
- Started by The Gent
- Replies: 29
Good day all, I am trying to do something which it my head feels quite simple but I can't get a result. I have four dimensions in a spreadsheet... -
Inserting text above first blank row then above third blank row etc.
- Started by Livin404
- Replies: 24
Greetings, I have a VBA where I'm trying to insert text into blank cells. On worksheet "Deficiencies" I have seven groups of ranges that I... -
code to get students marks from source sheet to destination sheet.
- Started by rzml
- Replies: 22
hi, I am looking for a VBA code that can get student marks using his ID and evaluation type (as headers) from source sheet to destination sheet. I... -
Run VBA on all open tabs
- Started by Dannottheman
- Replies: 22
Hi, I searched but could not find an answer to this. How can I make the 3 VBAs below run on all the open sheets/tabs in my Excel? Right now I... -
Functions to separate a string separated by commas
- Started by jeffdolton
- Replies: 22
Hi, I’ve opened up another thread as my request this time is a little different. With help from experts on this forum, and using some basic excel...