#macro #vba

When I Click cell C8, I should see the command button shown in E8 not otherwise via vba coding. i was follow this code but not working pleased help me : Private Sub Worksheet_SelectionChange(ByVal Target As Range) If Not Intersect(Target, Me.Range("C8")) Is Nothing Then...

I want convert all textfiles in current folder from UTF8 to ANSI with same name. Please guide me about it. (vba) Thank you

Hi Guys, Can you solve my problem. I try to copy pastevalues using macro, but instead of copied to the right I want to copy it to the left. because the data in the right already fill with certain data. I already attach the example. Thanks before Note: "sumber" is the data source, and...

Hi, I have been searching for a macro that will copy and paste data that I have in multiple worksheets to my "tremplate worksheet". I have seen a lot of posts but none of the macros totally works for me (I am new in this). If someone could please help me I'd be very gratefull. I attach an...

I am totally new to Excel VBA. But I have a requirement to copy some data from let us say sheet1 to sheet2. I have several columns and rows in sheet1 (source sheet). Now I have to copy only Five columns data from within that where "Ferro Manganese" found in particular one coloum and if found...

Hello, My colleague has recorded a macro which works for 2 of our team. However when others try to use it they get a "Compile Error: Named Argument not found". I have done some research and I think I understand what a Named Argument is, but I don't understand how its created or why it works...

Dear all expert, I am doing some macro vba to select a cells that contains specific text in a table. and I want to delete the adjacent cells cotents of the selected cells. I am new to vba and need your assistance. Thank you. On table 1 ,i have few "DONE" text. and I want delete the cells...

Hi, I want to copy and paste the columns value to outlook mail from same excel sheet, OS : Windows-8 Outlook : Outlook2016 Below are code i have and request you to help for other part. Private Sub Button50_Click() On Error GoTo ErrHandler ' SET Outlook APPLICATION OBJECT. Dim objOutlook...

Summary: I am trying to find a macro that pulls differences in data into another sheet. I believe a macro would be best in this scenario but any assistance would be much appreciated! Scenario: I have two reports. One in each sheet. Both reports have identifying numbers in column A that...

Hi, I am trying to create a macro that will look at a cell to find a file path, find a file name and find which tab to use. I produced one of these 2 years ago but I have not looked at macro's since and hence can't remember anything. essentially, I want there to be a summary tab with a cell...

I am trying to write a VBA Macro to a assign Actions to be taken (Column L) and Status of the component (Column M) based on the value of Size1 (Column C), Size2(Column D), Lot No (Column E), Item category (Column H) and Delta (Column K). Criteria which I'm using is as follow: If Lot ≠ Lot No...

I am needing to retrieve the account number from every excel document in a folder including sub folders (roughly 3000 excel files) . The account number is in the same cell (G23) on all excel workbooks. Ideally the macro would return cell value in column A and in column B have the file location...

Hello all, I have a main file that gather information from 2 other files and needs to be updated every Monday. All files have the same structure (seen below) and I need a macro that will check the rows for the incident number from the slave files and determine if the status is different in the...

Hi, I am trying to write a simple macro that will color a cell's font green if a cell links to another cell in the same worksheet. (I have come across macros online that will color a cell's font if it links to another cell in a separate worksheet or workbook, but unfortunately, nothing that...

Hi, I'm not an expert in excel, however I do feel that Excel can do the stuff, that I'm talking about in my below problem I need the following to done with the help of VBA. a) Click on a link provided in excel and open a webpage. b) Wait for IE to open and then click on a specific location...

Hi, I want to create outlook appointments in outlook 2010. Below is the code which creates appointments. Few issues which I need to fix --> How do I invite attendees, if any? Below code creates duplicates :( For instance if the appointment is altered, how do I ask the macro to update the...