line

Hi, I have a year's worth of log files that i am reading into a single sheet. The data is tab separated. (I can't get it working using vbtab so use chr(9) instead). Everything is working except that in each line there are two dates, one in the first column for when the alarm changes and one in...

I have a simple table with line numbers (1,2,3. . .x) appearing in Column A. Cell A1 is 1, Cell A2's formula is A1+1, Cell A3's formula is A2+1, and so on. This creates problems if anything gets moved. What is a good way to keep the line numbers sequential when a row gets added, deleted, or...

Hi Can someone advise whether this is a way to replace the line marker with number label, like the picture below? https://ibb.co/CVc5HPf

Hi, Can this code be edited so it puts the data on the next available line? I sometimes need to delete some data. Thanks Private Sub CommandButton1_Click() Static xCount As Integer Application.EnableEvents = False Range("J3").Offset(xCount, 0).Value = Range("H6").Value...

Hi, =ANTALL.HVIS(Bruker0:Bruker150!E5;"1") Translated to english Excel: =COUNTIF(Bruker0:Bruker150!D13,"1") This doesnt work: On the shetts Bruker0, 1, 2.. I Got a value in the D13 that range between 0 to 5. I want it to sum up the numbers, in the case over, 1 and tell me how many 1 there...

Hi, I have a graph based on a 3-column data table where x- axis is time (months, Jun 2019 to Dec 2020) Primary y-axis is account balance ($0 to $3.5m) Secondary y-axis is PnL (-$300k to $200k) August 2020 is first month PnL > $0 (Aug 2020 as the answer is calculated in a different cell) How...

Hi, to those who use vba regularly, I'm sure this is an easy one. I have an excel spreadsheet with a number of columns. I currently paste data into email fields to send. I currently send 14 emails. some emails contain more values than others, example below. First email To D2 Subject "Test...

I am looking to plot a line graph with upper and lower limits (Ranges). Attached is the target view (PNG). The value that I have, has positive and negative values. Hence showing upper limit and lower limit range in the line chart is a bit complex. Attached is the excel sheet(Sample.xlsx) with...

Hello guys, I need my macro to open the Attachment Files button inside a Purchase Requisition and tell me the file name attached. I was able just to get the "PDF" text, but not the name itself. https://imgur.com/d2WF0Q0 This is the line code I used to get the "PDF" text, the rest of the...

Hi, How can i get the first line value of the collumn with "1" value and print the result on the last column like in example above: <img src="https://i.ibb.co/R9WBhzq/Capturar.png" alt="Capturar" border="0"> Thank you very much.

I have a pivot table that is working out weighted average, now my issue is that the Grand total does tie back to the line by line version, any idea why? The Grand total is saying 78.56% but if I calculate it line by line its 78.14% what is causing the difference...

Hello everyone. I am back again. The code bellow is working to an extent. However, when I click OK to the Error I get, it clears the field BUT the customer name field (tbnbna) does not get the setfocus. Private Sub tbnbna_AfterUpdate() If Application.WorksheetFunction.CountIf(Range("A:A")...

Hi, how can I remove lines within each cell (multiple lines with line breaks) that are not starting with a numeric character? <tbody> 223213 - this line needs to stay chair - this line needs to be removed 9 - this line needs to stay needs to be removed </tbody> Thanks and best, Jack

I have an activex text box that I need to expand down as more text is entered. It is set to a width of 540 and when text reaches the edge, I want it to go to a new line and for the text box to grow one line larger. If it is deleted, I need it to shrink the text box to fit. It must stay at the...

While reading a TXT file the following occurs: Such a line like: "31/07/2019 TOTAL" At this line I suppose the "Input #1 , sTxt" instruction is reading read as there was 3 lines in the TXT file: "31" "07" "2019 TOTAL" I expect that this instruction will read the entire line "31/07/2019...

Can someone please help me in the below error. Method Introduction of Object IMsomailenvelopeVB failed The code runs fine with some users but throws the above error for some on the below line, . Introduction = Sheet3.Range("D2") Quick help in this is highly appreciated.

HI There I have uploaded 'Published' my Excel workbook in the internet , but the ActiveX controls DO NOT show up in the 'on line' version of Excel and hence my users cannot use the internet interface. Is there a solution to this problem. Thanking you in advance Martin Argimon ( South Africa)

Hello, I have a list of information in a column that I want to concatenate into a single cell. I need a line break between each line of information but the problem that I have is that as I don't know how much information will be entered into the column each time. I have allowed for possible...

ok sorry for this but i am brain dead at the moment I am trying to create a line chart to show the difference in test scores over the course of several years i am hoping to have one chart with a "blue" line and a "red" line (lets say) showing each score in a given year winter 2017 student K...

Is it possible to put a marker or line signifying today's date on a chart? I want this line to automatically move based on today's date =TODAY().