element

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...

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...

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 -...

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...

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...

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=""...

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...

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...

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...

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"...

<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...

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...

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...

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...

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

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...

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...

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...

=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...

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!