1. P

    Variant-type object array element is deallocated by With statement

    If an object-array is declared as a Variant type (in order to easily check whether it is initialized using the IsEmpty function) then, if the subsequently defined array's elements are referenced as the object-expression of a With statement (e.g. "With VariantObjArray(i) ...") then that...
  2. I

    How to edit this copy and paste VBA code to include duplicate values?

    Hello. So I have two workbooks here. I have attached screenshots of both. One is Pickorder. Column A lists the dispatch times. Column B has route codes. Column D has the dispatch areas. Column E has the dsp taking the route. For example, CX19 dispatches at 6:15:00, at STG.A01 for HIQL. I then...
  3. D

    HTML Through VBA - Trigger event on HTML Form

    Hi, Long time fan, first time poster. Also this is my first attempt at manipulating web stuff, so apologies if any phrasing is misleading. I am entering data on a website (to autoamte a data scrape). There are 4 fields: - Post Code (Text box) - Occupancy (Drop down) - Building Type (Drop down -...
  4. T

    For Each Loop

    Following from this thread: https://www.mrexcel.com/forum/excel-questions/1114405-collections.html I was told this piece of information: Syntax ... For Each element In group ... element ... For collections, element can only be a Variant variable, a generic object variable, or any...
  5. B

    Appending a Value to Each Element of a Range Array

    I have a workbook with 2 sheets: Sheet1 and Sheet2. In Column A of Sheet1 I have a short uninterrupted list of product IDs: <style><!--table {mso-displayed-decimal-separator:"\."; mso-displayed-thousand-separator:"\,";}@page {margin:.75in .7in .75in .7in; mso-header-margin:.3in...
  6. S

    Copy status value from web page

    Hello Everyone, I am not expert in VBA. Requesting your support to complete my macro. In the webpage I want to copy the status "Awaiting Business Review" in my excel sheet. Below is my HTML Code.. I cannot disclose the website address. Apologize for that. <div title="" class=""...
  7. W

    What does this mean?

    HI, I've been using this formula for some time and I can just about fudge the way it works. =SUMPRODUCT(SUMIF(INDIRECT("'"&Courses&"'!b:b"),$B4,INDIRECT("'"&Courses&"'!"&SUBSTITUTE(SUBSTITUTE(REPT(ADDRESS(1,COLUMNS($A:G),4),2),1,":",1),1,"")))) I understand its looking at the named range...
  8. D

    How to skip rows

    Hi Guys!! I'm using the Hyperlink function for a database with different sheets. On my main sheet I have the label of each element, and on my second sheet I have each element with an individual table with some data. The issue is that I need to link the label on the first sheet with the table...
  9. M

    Placing an Autofiltered range inside an array works only once

    I'm currently having a problem where an auto-filtered range is only placed inside an array on the first loop but subsequent attempts to do the same despite the range filtering correctly don't work. Set OpenWBS = Workbooks(Workbooks.Count).Worksheets(1).UsedRange...
  10. H

    Web-Scraping Selecting Dropdownlist in website

    After button element "ContentPlaceHolder2_btnSearch" is click, element "cbSite_I" returns to blank. I want element "cbSite_I" to have value "Cát Lái" after element "ContentPlaceHolder2_btnSearch" is click. Pls kindly help me accordingly. Thanks. Visible Text on websit : Button : "Search"...
  11. R

    Access with formulas and fetch values

    <tbody> BIN ELEMENT# TTL LV2 LV3 LV4 1234 12 200 150 50 0 1234 13 150 130 10 10 1234 15 350 350 1234 18 10 10 1234 201 255 255 1234 340 30 25 5 1 </tbody> Secondarytable ^ main tbl ex. below <tbody> BIN ELEMENT X...
  12. J

    Data quantity calculations & summary across multiple tabs

    I have a workbook for budgeting construction projects. Each element of a project gets its own tab (for example, walls, roof, floor, etc.). Within each of those tabs the user chooses a category of material from a drop down menu, then the actual material from a second drop down menu. Those drop...
  13. B

    Selecting info based on a previous column

    I have a list of data made up of four columns, Element, Feature, Attribute, Life Expectancy, an example would be fire access & security systems(Element)>cctv system(Feature)>recorded(Attribute)>25(Life Expectancy). Each one of the columns is related to the previous one, so if I was to select...
  14. Sharid

    Email Extracting

    My code extracts emails from a website, this bit is fine It can also extract URLs from a site, the PROBLEM is that it extracts all LINKS and not just the domain name Also I can only extract one or the other, either emails on their own or Links, when what I want is for it to be something like...
  15. R

    Need one more element to this formula

    How do I modify this: =IFERROR(VLOOKUP($A8,'D:\Corporate\Analytics\2019Analytics\Final2019\[NewsLettersJan2019.xlsx]Stations'!$A$3:$FC$156,64,FALSE),"") so the result is multiplied by J6 thank you in advance
  16. J

    Userform with input numerical number with listbox

    Hi, I found this code: Private Sub Worksheet_SelectionChange(ByVal Target As Range) Application.EnableEvents = False On Error GoTo exitHandler If Target.Column = 10 Then gCountryListArr = Sheets("RESOURCES").Range("Table2[COD]").Value gCellCurrVal = Target.Value...
  17. P

    Multiple Arrays and Loops

    I am comparing 2 arrays, and based off the comparison, placing values from an array into a range using the active cell. I am not receiving errors, but two things are happening. 1. Excel (not my machine) locks up when I run the code - How can I improve my code so this does not happen 2. I...
  18. G

    Drop down list returning another list element

    Hi guys, I deal with a lot of weird identifiers that I can never remember and I was wondering if it would be possible to create a dropdown list that returns an element from an adjacent list. So if you refer to the list below as an example, let's say my drop-down list would be counterparty...
  19. B

    Trying to use 2 VLookup formulas but need a "Then".....

    =IFerror(VLOOKUP(E3,_20181219_milly_final_2!$B$2:$H$175466,7,0),iferror(VLOOKUP(J3,_20181219_milly_final_2!$G$2:$H$175466,2,0))) Here is a formula that is not working --- I have 2 tabs and each tab contains account # and element #. I am trying to match acct # from tab 1 to acct #on tab 2 and...
  20. E

    Extract text between specific characters in a alphanumeric string

    Hello group, I am looking to extract text data that is between specific underscores. Example: ONE_TWO_THREE_FOUR_5_6_SEVEN_EIGHT_9_TEN_11 I need to extract element SEVEN. How can I specify to read between specific underscores? Thank you!

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back