code broke

want to make some changes in below code, need only 3 changes, help pls we have added the number in code where we need to change................. 1. Selection.AutoFill Destination:= it will select range E and last range of E will be till last filled data in D 2. range("E14:E1779").Select =...

I have a Mastermind game sheet that uses many command buttons. After several YEARS(!), it suddenly stopped working. I'm using Excel 2010 at the office but the workbook is saved as Excel 97-2003 for compatibility with my home PC (this has worked fine for years). The buttons are all enabled and...

Dear all, First off, thank you in advance to anyone who posts an answer to this question - I really appreciate your help! I am using Excel 2010 to try and make a macro that will try and automate a rather tiresome process of creating many excel workbooks with certain information extracted from...

I am actually fairly new to VBA coding and is at the point where I am trying to learn how to debug a current program given to me by a coworker that I wish to understand and possibly improve to suit my needs. Public Sub Patient_Records() Dim FF As Long, strText As String, strFile As...

Hello, So... I've been working at this for quite a while. I think the code needs a closing statement for the for, but I'm not sure. When the error produces ".EntireRow.Delete" is highlighted; however, it still deleted the rows correctly. I'm trying to make this template neat, so it works, but...

Hello again! This community has been so helpful with my previous problems I've returned with another. This could be something simple; however, I can't seem to figure it out. I stole this code (off this site?) and I'm trying to re-work it to compare two columns based off of the position of...

I have reviewed several similar topics and there is something I am definitely doing wrong. I have a worksheet called "ShipDtls" that contains data. I want the last row, columns 16 thru 20, data split (see link w/example: ) {link...

Hey guys, i was using the below code to insert new column and combine two columns into the new column while adding some text between the inserts but went to run it today and all of the sudden its not working anymore, i tried playing around with it and using good ol' google to try and figure it...