line

Hello I am looking for a free and fast way to manipulate large amounts of data (GigaBytes). I think Powershell is the most appropriate as it comes with Windows and it is fast. Do you have any other alternatives? As for Powershell, can you help me please with a script that will read the lines...

Hi, Im curious to find out how this is done? It's probably dead simpel but i can't seem to snatch it in google :) How do you add a line below the text in the cell with padding in the ends (as seen in A12-F12)? I've replicated with borders but the you lose the grey grid. Thanks! /Marten

I have a utility that copies charts and named ranges into PowerPoint slides. It worked fine until I added some code to (in bold below) resize the copied Shape and move it on the slide. Now it crashes with a Runtime error: 9 Subscript out of range (on the red line below) The DoEvents loops just...

Good Morning, I've got some ideas but none seem to be working quite the way I want them to..... I'd like a string of code that, when run, will take the contents of cells A1, A2, and A3 and save them in a .txt file, with each set of cell data being a new line (so the info of cell A1 is the top...

I am obsessed with terse code. The code below does the job (I recorded this macro): Sub copy_and_paste_as_picture() ActiveSheet.Shapes.Range(Array("Group 5")).Select Selection.Copy ActiveSheet.Pictures.Paste End Sub Can someone help me clean this up and turn the three lines...

Hi Team, please assist for breaking the lengthy formula line by using line Continuation When I tried getting error message, compile error expected list seperator or) its working formula Range("m2").FormulaR1C1 = _ "=SUMPRODUCT(ISNUMBER(MATCH(R2C8:R239C8," & cr1 &...

I have a form that adds data to a table, I have a macro that adds a new line to the table, but I would like to copy and paste as value the previous line once I've added a line. When I record the macro though it puts a specified range in but I would like to just have it say go up one line and...

Can someone as assist with a code that will enter a carriage (Enter) whenever the multi-line textbox wraps the string to the next line. I know the multi-line textbox will do this for me, but I need this to enter it a cell to indicate to separate line. Thanks for you

Hello, I hope this is something obvious, but I can’t see it,effectively the basic formula works, but when I transpose that to vba, thecolumn just remains blank. Effectively, I want the sum of the figures in column Q,where column G matches the name in the relevant line in the first line...

Hi all, I need a little bit of a help to make a formula... I might have two lines with the same component in a big list, and I want my stock figure to be updated in the second line based on previous calculation. I tried to use indirect and ROW()-1, but had no luck. So, I have a available...

Hi all, We have a tracker for stock waiting to be booked in. When our warehouse has booked in the stock, they enter 'Closed' into a particular cell, add a comment, and the line turns blue. How can I set the spreadsheet up so when the warehouse enter 'Closed', an email is created with the...

This line of code used to work. Now this, among a few others, doesn't seem to work. It kicks up a 438 "Object doesn't support this property or method" code and highlights the top line.... ideas? I can sort if I manually highlight and click sort.... Range("B3:K102").Select...

My company has just upgraded to 365. My previous version was Office 2013 I had code that copied the text from a selected cell to the clipboard. This now doesn't work in 365 The code is as below: Public Sub AddToClipboard(s As String) Dim oCopy As DataObject Set oCopy = New...

Hello All I am looking for a way to loop through specific columns i.e. columns # 27,30,38,39,47,48,50,52,53,54,61,72,74,75,76,77,78,79 and in each of those columns, copy a formula from the first cell at the top of that specific column, down to all the rows in that column (lets say from line 3 to...

Hello guys, I have an excel file with some records that are copied/pasted from a website. Due to the site's structure when I paste the data on excel, some cells cause the line to split (see an example below) and the surname of the person goes to the below line which except this cell all the...

I am doing the parent, child method on the treelist that i am doing on a workbook. The list of data i am trying to make into this list is extensive. I am looking for suggestions to the worksheet i am linking on how to either layout my list better or be able to select specific cells. The...

Hi folks, I regularly have to compare 2 report lists (approx 10,000 rows on each report) that are nearly identical. However, there are always 3 types of differences (sorry my title says just 2 I couldn't edit it) throughout and I currently spend a lot of time finding/listing these differences...

Hello, I have a budgeting sheet where I'd like to show a vertical line against some progress bars at a value other than zero. In particular, I'd like to highlight where budgets are at more than 100%. It looks like conditional formatting can only handle that if the value you're targeting is zero...

Hello friends, Hope all is well! thanks to you, I succeeded in hiding the ribbon by using the below line. problem now: validation dropdown menu is not active. if I remove the below line the validation works. please help me remove the ribbon and allow the validation's dropdown menus to work...

I am needing to have a TEXTBOX be updated from a button that takes some info from my Combobox's and puts them into the TEXTBox 1 line at a time. But I will need to keep adding to this until i am ready to complete the data to send and then clear it out. I have tried using: TextBox1.value =...