excel vba 2013

Hi, I have some code that needs to be updated but I'm not sure how to change. I am trying to save as into Excel 2013 excel workbook. This is the code I have: FileSaveName = Application.GetSaveAsFilename(InitialFileName:=ActiveWorkbook.Name, FileFilter:="Excel 2003 (*.xls), *.xls")...

Hi, I am trying to format date over range of cells using Format(). Sheets("Details (Deliverables)").Range(Format(CDate(Cells(i, "N")), "dd/mm/yyyy"), Format(CDate(Cells(i, "W")), "dd/mm/yyyy")).Select I got error for this.I having Excel 2013. I tried using .NumberFormat but it is not working...

Hi is there a way to make Excel column data alternating. For example : I would used it to evenly ditribute data to personnel so they would have a mixture of data and not only handling data with tagged as New or Old. Thank you

Good afternoon, I was searching the forms and thought I would find the input to my hurdle. I am trying to extract records from a detailed worksheet into separate sheets but only specific columns. I thought I might find a script for each of these two steps and merge the scripts together, but I...

I have a huge text file that I want to extract specific data and put each one it into a column in excel. I not even sure how to start. I've only done simple code in excel before. The data in the text file looks like the following date. Report name Page number time run option: print...

Hello, I am learning VBA and have a large code that formats an Excel spreadsheet. The code works, but I just want to see if there is a better way to write the code of Autofit and Autofilter than what I have below for the sake of learning. I ask, too, b/c I hear some people say to not use Select...

Alright I've figured out a lot of ways to copy and paste data, but none work how I want them to. If I have set cells and ranges from sheet 1: B3,B10,B17,B24,B31,B38,B45(Cells) C2:H7,C9:H14,C16:H21:C23:H28...

Hello, I'm learning Excel VBA and I would appreciate help. I'm trying to highlight a row of data in one workbook (Table 1) if criteria in column A matches criteria in column A of another workbook. I need help referencing the other workbook without naming it explicitly, the...

Hi everyone... I selected 5 shapes and defined a name in "Name Manger" the name is (MonthlyReports), iam trying to write a short code to make them all visible or not. the code should look something like that shapes.group("MonthlyReports").visible=false and obviously it's not working,

Hi everyone , I have an excel file that contains my data , and a word form . I want to fill The word form with my excel data . (I've bookmarked texts that needs to be fill out ) for example i want to choose row 2-10 in excel and and click on a button to export 9 word document that filled out...

Hi, I wonder whether someone may be able to help me please. I'm using the code below to copy a selected range of cells, create a new workbook and then paste the data into sheet 1 from the source to the recipient sheet. Sub copysheet() Application.ScreenUpdating = False Dim Src As...

I can populate a userform combobox (cboPnum) using vba and additem method (2 columns) When the user selects an item in cboPnum, and then enters a qty in a text box (tbQty) the correct information is then added to a listbox (lbItemsShipped). All great so far... What I cannot fathom, is how to add...

I am wanted to simplify the task of transforming 1000's of data in rows into a table with specified column headings. I do manual copy paste of data which is tedious. <colgroup><col><col><col><col></colgroup><tbody> g l m 1 PT-55002 0 135 2 PT-55002 0 135 3 AIT-98932 -200...

Is it possible to remove a string if the exact same string is contained in the cell above it? How about below it? Example: <tbody> A B 1 Step 1. Place the key in the ignition. Step 1. Place the key in the ignition. 2 Step 1. Place the key in the ignition. Step 2 Turn the key...

I have extracted a rather large XML file. Inside the file was an old method of how I stored my invoices. Here is the string of text that I have: Data sp 199 blah blah blah blah blah 60 cbl blah Door 999 blah blah blah blah 299 sp door 888 blah blah Here is what I am looking to get done...

I have extracted a rather large XML file. Inside the file was an old method of how I stored my invoices. Here is the string of text that I have: Data sp 199 blah blah blah blah blah 60 cbl blah Door 999 blah blah blah blah 299 sp door 888...

Sub macro1() If IsEmpty(ActiveCell.Offset(0, 10).Value) = True Then 'checks to see if the field is blank first ActiveCell.Cut Destination:=Cells(ActiveCell.Columns("j")) ' <-----heres where I go fuzzy, had it working from colB to J, but my colB will change...

Sub Macro5() Range("b1").Select For counter = 1 To 10 ActiveCell.Select Range(Selection, Selection.End(xlDown)).Select Selection.Cut Range("a1048576").Select Selection.End(xlUp).Select ActiveCell.Offset(1, 0).Select ActiveSheet.Paste Columns(2).EntireColumn.Delete...

I have columns up to ("PL") and I would like to remove duplicates from each column. Sub Macro3() ' Macro3 Macro Selection.EntireColumn.SelectColumns("AA:AA").Select ActiveSheet.Range("$AA$1:$AA$96769").RemoveDuplicates Columns:=1, Header:= _ xlNo...

<colgroup><col style="text-align: center;"><col style="text-align: center;"><col span="2" style="text-align: center;"><col style="text-align: center;"></colgroup><tbody></tbody> <tbody> A B C D 1 String BadWord GoodWord 2 baseball hckey hockey 3 hockey basebll baseball 4 I love...