vba "&"

I am new in excel VBA, I am looking for an Excel VBA code that will delete all the outlook email files (.msg) saved in local windows folder using 2 conditions and keep the last dated email file. The email files are from different suppliers that supply cement, steel and other construction...

Hello users on MrExcel. I am still a Newbie at VBA, so this question might seem a bit dumb, but i have tried to find a solution for the past 2 days, on and off. Lets just say, for the ease of it, that i have a Cell with the symbol ">", and it can change to "<" The cell i defined as "s" and...

Hello everyone, I have been running into a VBA runtime 1004 'Application-Defined or object defined error' Below are the code that have the issue. The weird thing is that when I open the workbook they will never run the first time, but after I run it couple times, they will magically happened to...

Hi All, I'm trying to find all instances of a client name and copy the range into a new workbook where I want to perform a calculation. These are my headers and I want to do a find on the client account number, such as 5 and then copy the range. My existing range runs from A1:I71573. I have...

I have a company website, my job is that when logging in to the site with ID and Pass, the site will display a link, I click on that link will generate a new Web window and I will push data from excel to that new Web window. I have set my VBA Code to login and click on the link successfully but...

Hi all, I need your advice as I cannot seem to amend the code to ignore words that are part of a text string. For Example: So that it finds the WHOLE WORD "IL" ONLY??? I want it to replace IL, but it's replacing letters from names like, Bill, for example. I have tried amending this partof...

Dear All, Please advise me how to activate the below (1 & 2) Codes to be functioning on the same sheet and your help is highly appreciated. 1) To show the user name on specific cell based on another cell value Private Sub Worksheet_Change(ByVal Target As Excel.Range) If Target.Column = 1...

Hello everybody, I am currently sitting with the following material overview file in Excel: I have made some conditional formatting so whenever I enter a number in column E the entire row gets highlighted. Unfortunately, this erases/makes invisible my dark gridlines/borders from before...

Hello everybody, I have the following list of information: Is there any way in which I can alphabetically order this list with respect to column B? Would greatly appreciate any assistance I can obtain! :) Thank you very much everybody. Best regards, David

Hello everybody, Goal: I am currently trying to create a command button in Excel that, when one clicks on it, sends out an email to me with an order that one has entered into Excel. The following link here: Using Excel VBA to Send Emails with Attachments - wellsr.com has a nice VBA code that...

I'm new to VBA scripting trying to write a condition for the table, The condition is to take the fail status and loop through the same table and find if the appropriate ID has a pass status, if yes i need to delete the record, if no i have to retain the fail status. so my output will be i...

Hi all, I am trying to pull the date from the top in row 17 to another sheet if there is a value in row 21 and if Q21 = OCP In addition I want the date to go to one of the following cells and fill from top down. For example in the above picture it would only pull the date from R17, T17, V17...

Hi guys n gals, I’m struggling and could use a bit of help please. I’m not sure if it can be done through Vlookup() etc, or needs to be a bit of code. Sheet 1 I have a list of CLIENTS; their GEOGRAPHICAL LOCATION; STAFF ALLOCATED TO THE CLIENT and an empty column where I want the AREA THE STAFF...

Trying to make my "time spent versus time allocated chart" update when new values are inputted in the chart below it. Cells K35:N60 are populated with formulas that will only show a value if they are inputted on another sheet. K35: =IF(ROW()-ROW(K$34)<=SUM(IFERROR(--(('Project - Gantt...

hi this code used to work in the past (open email form drive, filled send to and displayed email ), probably with older version of outlook, excel. now this code exits form sub at myRecipients.Add ws_names.Cells(i, 1) thanks for any suggestions Dim ws_names As Worksheet Dim...

Hi All, I'm newbie to the VBA, I'm planning to do some vba project. My problem statement is, I've an excel sheet with SHEET 1 (Where i'm planning to keep all my macro functions) And Sheet 2 (My master data sheet), sheet 3 .... I've to do below operations 1) A drop down list combobox which...

hi, how can I add column 1,2,3 here instead of column 3 only? I want to compare three column to get the unique value. str=ar(i, 3) Full Code Option Explicit Sub SumandRemove() Dim ar As Variant Dim i As Long Dim j As Long Dim n As Long Dim str As String n = 1...

Hi How can I check, if cell a1 or cell b1 contain numerics data/value or not in vba?

Hi there, I'm looking for advice on the best way to go about constructing a module to get my desired result. I have a commissions file that i want managers to be able to go in and review the commissions. Each manager will have a username and password. Each manager will require access to...

Hello my peers, I was wondering if anyone has come across a piece of code that can select open an excel file and list the tabs in the opened workbook in a diologe box for the user to select.