line

I have a bunch of data that looks like this abc, def, 123, ghi The lengths of each string aren't consistent line over line. If an entire worksheet was like this I'd just go to Data/CSV and open it like that but this is just a small range. How would I separate values that are currently...

Looking create a macro that adds a new line WITHIN a cell, Starting by adding the current date, then i add notes My failed Code resulting from "recording" of keystrokes: Sub dw() ' ' dw Macro ' Application.CutCopyMode = False ActiveCell.FormulaR1C1 = _ "10/3/2019-> Lead team...

Hi, I have an optimization problem, that I'm trying to solve in Excel, but it keeps getting too complex (too many columns/iterations), and I hope someone in the forum may be able to give some pointers. On a given day, at a given timeslot, I have 6 production lines, each with different...

Hi I want to copy a text from internet to Excel. I ctrl+C the text from the internet, then in Excel, I clicked on Paste-->Special -- then select text. Everything copied fine only one issue, some lines are so long. It looks like taking the whole row. I know it is only in one cell A1 for example...

I'm sorry in advance if the answer is painfully obvious, but I am not very knowledgeable when it comes to macros. I am attempting to copy the contents of cell "C2" and paste it a line above the first line in "textbox2" or a line below the last line in "Textbox 2" while keeping the text that is...

Hi I have a workbook that compares missing data and duplicates and put in column F if missing and column N if duplicate. At present it looks up to line 9999 and its extremely slow and sometimes misses missing and duplicated data. My data will not always go to line 9999 and wondered if I...

Hello All I was wondering how do I change the dot size (plot points) on a line graph Mine are too big Thank you Jason

Please check the below table for each leasing agent: <tbody> Client <tbody> Status </tbody> Just Browsing Interested On the Fence Hook Line & Sinker Lead Lost 1 Active <tbody> 14-Jul-19 </tbody> <tbody> 15-Jul-19 </tbody> <tbody> 16-Jul-19 </tbody> <tbody> 17-Jul-19 </tbody>...

So, in my spreadsheet, I have an existing macro that uses: Shell ("C:\Program Files (x86)\Google\Chrome\Application\chrome.exe") So I'm pretty sure that it is the base of what I need to use for this other program, but the other program I need to use a shortcut which has a command line switch...

Hi All, With a UserForm TextBox you can limit the number of characters to be used in the TextBox properties MaxLength behavior. I want to know if your set the MultiLine to True, can you limit the number of lines that the user can enter. For example I have a UserForm with a TextBox. I want the...

Hi I currently have data on stocks, next the the stock price I have indexed it to a certain date which I can set. I have then graphed this data on a line graph. I'n trying to find a way to have a vertical line in the line chart showing where my data is indexed. Is anyone able to help with...

Hi, I have a code for listbox with textboxes. how can I format the box to $ currency by adding this line of code to each box that has dollar amount, I would like to add this line of code: " & Format(Range("E").Value, "$#,##0.00;($#,##0.00)") to this code: (Bold and red colour) Private Sub...

Hi I realize the title is not that helpful I have a relatively large spreadsheet - around 7 MB - with a lots of calculations and 50+ tabs It calculates fine and very quickly. However, my problem is that if I move a tab or insert a blank line (even if that line does not impact any...

I am trying to handle multiple errors and am a bit surprised the following actually works: On Error Goto Errhandler ' Do something Exitpoint: On Error GoTo 0 ' OK this line is not actually needed. Exit Sub ErrHandler: On Error Resume Next 'Do something...

I watched a youtube video by Amjad Pervaiz on making rev clouds in Excell. He had a add-in called "cloud.xlam" that would convert a rectangle to a cloud. He could adjust the arc radius, color, and line thickness. Does anyone know where I can get a copy of this add-in?

HiI have created a table & in column B I enter a number (i.e 3) is there a way to automatically add 2 rows below the line, so if the number was 5, it would add 4 rows below?RegardsStephen

Im looking to have a line chart that shows a % for the number of sku's that were delivered on time. At present everything shows at 100% ( which is wrong, as some sku's were delivered outside of their 2 day SLA ). Im not great with charts , so could do with your help. Axis: Chart Date Values...

Hi Guys, I need to change a multiple line excel sheet to the a single line sheet. I have the below sheet <colgroup><col style="width: 25pxpx"><col><col><col><col></colgroup><thead>#DAE7F5[/URL] "] A B C J </thead><tbody> 1 Exported On: 16/08/2019 15:40:57 2 #00DC00[/URL]...

Hi Guys I have an excel sheet where a User Name is appearing on multiple lines (See below) And we want it to appear as below

I have a spreadsheet that will have x number of lines added to it. When all lines have been added, I have a button that inserts a signature 5 lines below the lowest part. The lowest part is a line at the bottom. Underneath the line, there is a textbox that will have notes written in it...