vba. excel

This code below adds a column next to the search term in the header on the right. How do I change this to add a column on the left? Will there be a good soul here that will help me solve the mystery? At the beginning Auto By foot Current status Auto Bike By foot...

Hello everyone I'm new here.So it's possible to pull data with filter criteria in each month to same month in another workbook

I am working on a worksheet with multiple tabs although I need to copy data from worksheets that start with only "2018 and 2017". From these sheets I wanted to copy range - using variables (say I wanted to copy a range between column A to L but the range should be dynamic ) and then paste the...

I'm training to write VBA code that combine two sheets data rage to one email and send it. I used below code for my debug but I failed to do so time after time. Below code send one sheet range data and I want to add it additional rage from sheet2 (Worksheets("Sheet2").Range("b3:b30") Sub...

Hi, I'm new to VBA. I need a VBA macro which can change the colour of the cells based on rules applied. <tbody> B1 B2 B3 B4 B5 0.00a 0.00a 0.00a 0.00a 0.00a 0.01a 0.02a 0.00a 0.00a 0.00a 0.03b 0.01ab 0.00a 0.00a 0.00a 0.06a 0.03a 0.07a 0.04a 0.06a 0.15a 0.18ab 0.27b 0.26b 0.22ab...

arr1 = Array("m", "n", "o", "p") With Worksheets("Sheet1") With .Range("B3", .Cells(Rows.Count, "M").End(xlUp)) celltxt1 = Sheet1.Range("b:b").Text If InStr(1, celltxt1, " *abc* ") Then 'do nothing Else: For Each cell In Range("M:M") If...

Hi Experts I have created a macro in excel which sends the email via outlook to more than user at a point of time. The macro is working fine when I add plain text in the cell, which I am using for the body of the mail. The issue is when I am trying to add the table field in this cell. It won't...

I have a macro that selects worksheets to be printed from worksheets that carry a value in cell A1. I am trying to adjust the code so that it will print the pdf file with a predetermined name, eg "Output.pdf" and into the folder that the excel file is currently saved I do not have the VBA...

Hi, I am trying to delete any duplicate row based on column "C" data. I have sorted the data so the data is sorted by "C" the account number and then "E" the date with the eldest first. When I run this code it does not pick up all the duplicates and does delete some that are not duplicates...