vba & excel 2010

I want to extract specific numbers after some specific words from textpad and I have to write that into my excel columns i.e example, the textpad file is like this *INFO* CRITERIA is MATCHED. DISPLAY ID 123456 AND AT T=369 MAY BE MATCHING OR MAY NOT BE *INFO* CRITERIA is...

Hello everyone. I am here trying to see the transformation from a simple Macro to a Code, I know guy for you is something so Simple, but “ sorry “ no for me, I am a new self-thaught bee. I just sum two numbers with the macro recorder I got this: Range("H2").Select ActiveCell.Formula =...

Hello. I have a little snipe code able to tell me how many times number 1 is in the column A, I am trying to count how many time 2 is after one, but still I don't know how to say that in VBA. This is the little code: Sub countmontecarlo()Dim cell As Range Dim n As Long For Each cell...

Hi all, I am current in the process of trying to automatically send emails via outlook from data found in my excel spreadsheet. Here's what I've done so far; Sub Send_email() Dim sh As Worksheet Set sh = ThisWorkbook.Sheets("email") Dim Outlook As Object Dim msg As Object...

I am trying to apply autofilter and then copy the filtered results in one sheets using the below code . But it is throwing an "Object Variable not set error " Please help Code Sub CopyDataWithoutHeaders() Dim ws As Worksheet, DestSh As Worksheet, Rng As Range Set DestSh =...

Hi, I have the beginnings of some code to insert three rows below each row which has a name and ID to then populate those three new blank rows with the name and ID from above. I also have some code in the macro that should identify the end of the data (the first blank row) so that the macro...

I have never created a macro in excel, and last night I was trying to and I created an IfBold Macro by reading on this website, however it did not really do I really needed to do. I would really appreciate any help I can get. I am this General Ledger Activity report that I need to convert to a...

Hi there, I have check boxes in column L (L20:L64) which I would like to be hidden, when the row is hidden. Currently all the check boxes are clustering together on L65 when any rows are hidden. The rows start off as being hidden and once data is entered in column B, the row below is unhidden...

Hi there, Not had to write a code like this so have taken a stab in the dark but it's not liking it. Can anyone see where I am going wrong please? When I try to run it, the error highlights the second row of code (If Not Intersect...) The "Entity_Type" is located in cell D8. The "Entity Type"...

I am trying import data from 3 worksheets in a specified work book. My code works to delete the existing data in the destination wb. When I the code gets to the import commands it does not import. I have checked the file names and they match. When the resource actuals wb opens it is read only...

Hi there, Can I refer to a range and row reference in one line of code? Eg. Case 0 Range("208:604").Rows("619, 629").EntireRow.Hidden = True So I would like to hide range "208:604" and single rows, 619 and 629. The above doesn't work. Thank you!

Hi All, I need VBA Macro to read worksheet and output 10% each category from one column. Data like this Name IDs A 1 A 22 A 33 A 444 A 555 A 666 A 777 A 888 A 999 A 1000...

Hi there, Before I go back to the drawing board, can anyone see whether they can get this VBA code to work? Basically, I have two drop down lists. One is "No. of Investments" and the other is "No. of Partners". I would like certain rows to hide, depending on the result of both drop down lists...

Hi I just learned VBA, I made code like this Dim xRg As Range 'Update by Extendoffice 2018/3/7 Private Sub Worksheet_Change (ByVal Target As Range) On Error Resume Next If Target.Cells.Count> 1 Then Exit Sub Set xRg = Intersect (Range ("c4"), Target) If xRg Is Nothing Then Exit...

My goal is to highlight the cell when I have a filter active in the pivot table row & column labels. I have found the linked document below which shows me how to accomplish what I'm looking for in regards auto filters. What I would like to do is perform this same action in a way that functions...

Hi, I have data in a sheet with something like this: <tbody> A B C D File1 Abs 145 YuoJ 002 RFG 234 3op 009 File2 UYR 234 yyt 3nn POC 778 www 334 File3 WEF 778 O93 R67 TRE 778 87K 004 </tbody> I would like to colorize with the same background color all rows that...

Hi, Columns A:G in my spreadsheet contain "Yes" or can be blank and there may be rows where there is more than one "Yes". I have a dropdown in cell K2 where I can select the names of one of these columns and then I want to filter the data based on that column. There's probably a better way...

Hi there, I would like 3x input boxes to popup asking the user for information. When I just add the code for the first one, it works fine. However, I get errors when I add the next two codes. How do I amend the code so that each box pops up one after the other? Thank you! Sub ssFav() Dim...

Hi I'm new here, I'm Debbie and hoping to get some help with a holiday and sickness planner I have been creating. I am looking for a way to copy data from one worksheet to another in a different workbook (I'm using Excel 2010). I have identical column headers in two worksheets, columns D...

Hi all. I had some great help recently which has spurred me on to learn more and more VBA however I have a problem with the code below taking about 15 minutes to complete and wonder if there is a more efficient way of returning the required data. Even if I turn off calculations, I need to...