elements

I'm submitting a chemistry report but some of the elements are listed in % and some in ppm. I want to change all elements to %. The elements reported in ppm have an exclamation point in the cell containing the element symbol. I would like vba to copy each column and place the copied data two...

Array 1 = {"DX";"DZ";"WX";"TX";0;0;0;0;0} Array 2 = {"BX";"CX";"DS";"EX";"FX";"HX";"IX";"KX";"LK";"N";"NX";"OP";"SK";"SX";"TX";"WX";"ZX";0;0;0} How do I make an array that combines elements common to both arrays that aren't 0? I'd expect {"WX";"TX"} as a result.

Hi newbie needing to know how to declare an array where we don't know how many elements due to always increasing I have a list in A1 to A10 and need to use lastrow to declare array also would like to display msgbox after the loop to give a list of all items (don't know if this would be join or...

Ok so I'm about to move into the wonderful world of Access DB, but I want to continue to use my Excel skills. I intend to create a workbook that will pull just certain elements from the Access DB. I don't need to download the entire DB each time do I?

Hi, I am familiar with accessing the elements of a webpage using the CreateObject("InternetExplorer.Application"). I was wondering if there is a similar way to access the elements of Google Chrome and Firefox Mozilla ? Thanks.

hi I was wondering if it is possible to determine the elements within a declared Type. so as an example, I have a variable "Invoice" as declared Type Invoice Job As Integer CustomerRef As String * 20 Amount As Single End Type Dim MyInvoice as Invoice is there some way of...

Hello, I want to get elements image src links from web to my excel sheet, For example link: https://www.ebay.com/rpp/sales-events-en/GEO-Favorite-Fashion-FS-ROW/for-her Can I get this link ? https://i.ebayimg.com/images/g/5zwAAOSw3ydVwx4e/s-l400/p.jpg http://prntscr.com/i24m4t Thx for helping.

I believe this changed in Excel 2007 (from 2003) where this worked .Characters(1, l).Font.Color = RGB(153, 51, 0) I thought it was now .Font.ColorIndex but that didn't work either. Also, is there any way to debug.print all elements before ".Characters" to check what they are? Thanks.

I have 2 sets of data in 4 columns. In DB1 is the main database. DB2 is the information extracted from a vendor application. DB1-SystemName DB1-ipaddress DB2-SystemName DB2-ipaddress What I am trying to achieve using excel formulas is to map the data elements to DB1 elements. The...

I'll make an example. I have three groups: <code style="margin: 0px; padding: 0px; border: 0px; font-style: inherit; font-variant: inherit; font-weight: inherit; font-stretch: inherit; line-height: inherit; font-family: Consolas, Menlo, Monaco, "Lucida Console", "Liberation Mono", "DejaVu Sans...

I’m building a excel sheet where i’m using a template sheet that I copy to a new sheet whenever I need it. This works fine but I have one problem as I have created a group of control elements in order for me to maintain their relative location to each other. But when I copy the control it...

<!--[if gte mso 9]><xml> <o:OfficeDocumentSettings> <o:AllowPNG/> </o:OfficeDocumentSettings> </xml><![endif]--> Hello! As I got no answer yet and need it as fast as possible, I return to my message posted before on MrExcel forum. It’s focused on extracting some specific elements...

<!--[if gte mso 9]><xml> <o:OfficeDocumentSettings> <o:AllowPNG/> </o:OfficeDocumentSettings> </xml><![endif]--> Good evening! I posted yesterday a message on MrExcel forum, focused on extracting some specific elements (marked in the attached document by red colour) in two other cells...

Hi Guys, I have a small project of developing some VBA Code to simplify a spreadsheet for specifiing IO for Control Systems. In my VBA Code, I have utilised an Array in order to work with the specified spreadsheet range as CountIF will not do what I want it to do (Long Story). Anyway, I would...

Hi everyone! Here is a task about array, I can't resolve. I have the array like {text1,text2,text3} and I want to joint elements of the array in string like "text1text2text3" I try to use array formulas, but it doesn' work :( Why Mcrosoft haven't realize sum-like formula for text :confused...

Let me first say that this process does work when I am going from Excel (2007/2010) to IE 7/8, although it is slow it does the job. Essentially what it does currently is that it takes the address and copies and pastes it into the USPS website to check and see if there is a valid zipcode and...

Hi all, I have an array of data type Variant, who's elements are workbooks opened by a user. The array size is static, which for now isn't a concern but I can't work out how to close the workbooks in the array via a loop and the usual vba code of Workbooks("file").Close Code I have that...