excel-vba excel macro

Hi, Please I need excel to repeat text in a cell 2x That is REPT(text, 2) IF the text is not repeated, but if it is already repeated 2x, it should not and leave it that way. =IF(B2=REPT(B2,1), B2=REPT(B2,2), B2=B2) It gives me False, then 0 gives me true. Excel formula or VBA would be...

I have total 70 slides which I am getting by changing the slicer, My code is working to open ppt (which is backdated chart from excel) delete the previous object change slicer and add the chart then copy-paste the charts in ppt. The issue is that 70 slides is pasting after 1st 70 slides. because...

I need to use vbquestion 4 times as below 1. The first one asks if you need to upload the first file or not 2. Then asks for the second file 3. Then asks for the third file 4. Then asks for the fourth file 5. Lastly shows a message for the selected files using a string variabe if the...

Hi I have PowerPoint has 83 slides each slide have 12 images and 12 textboxes (textbox names for each slide start from 1 to 12) What I'm trying to do I have excel sheet which has all my data Column A has a slide number For the PowerPoint Column B has textbox name Column c has a title which...

Hi, I am trying to paste data from A,B columns from sheet1 to Aand B sheet2. For the A column , while pasting data I want to paste only numbers from each cells of sheet1. And for B column while pasting i want to remove first 10 letters from left and the paste it. Can someone help me with a code...

I have written this code and it has worked until now, I am still relatively new to VBA and now having issues amending the code, I have put two VBA Code: AutoFilter to pull certain rows, but I can't seem to work out how to only copy and paste visible rows, I have tried VBA Code: Set TempRng =...

The below one has written with specific range and in the same workbook in two sheets(sheet1,Sheet2) looking for your help guys,If row range changes dynamically(no specific range) and in two different books.how to write Different way of approaching the common column in excel is also accepted

Hi All I need your Excel Excel/Outlook VBA expert to help. I knew how to build up outlook VBA to detect new email with attached file (i.e. PDF file) coming in the specific folder but have the following problem : The email has attached file that is PDF file with password...

I stumbled on this method add a `PopUp Menu` from Ron de Bruin (I olso write to him but no react). It describes how to add a "Menu" is there code to add for example "Gallery" (I'm more interested in the gallery), "ToggleButton" or "SplitButton" ?

What I am trying to do is to send multiple emails to multiple clients with a click of a button, with each client has a different attachment. I can already send an email with an attachment, however, the second recipient also received the previous attached file sent to the first client prior to...

I'm currently trying to create a tool that will call/run another macro/sub when the enter key is pressed on cell B4. Cell B4 will be the search field. Whenever someone types something in this field and hits enter on their keyboard I want another macro called "searchcontains" to run I've...

Please see the attached image too. I want to copy the values one cell up to the last row. https://imgur.com/TQQplI7 Sub test2() Dim rOriginalSelection As Range Cells.Select With Selection .HorizontalAlignment = xlGeneral .VerticalAlignment = xlCenter...

hi heres my code but its keeping the sheet 1 text format when i want it to be like sheet 2 text and cell format Private Sub CommandButton1_Click() Sheets("sheet1").Range("A1:A4").SpecialCells(xlConstants).copy _ Sheets("sheet2").Range("A1:A4").End(xlUp) End Sub

I have two sheets on the first sheet, Column A have the project name, I have Columns K, L, U where I have dates that change on a weekly basis. On Sheet two I have same thing starting with A27, I have the same project names, however on F27, G27 and H27 where I manually enter the historical...

Hi, I have a macro and it perfectly run. however, the result is always shown at the right (latest column). image attached http://ibb.co/maG9L6 I tried to add the macro select.range("A1") or Application.Goto Reference:="R1C1" and it still not working. Is there anyone know how to make the...

Hello! I have some macro: Sub bracketsSub() Dim arr() As Variant Dim x As Long x = Cells(Rows.Count, 1).End(xlUp).Row arr = Cells(1, 1).Resize(x, 2).Value For x = LBound(arr, 1) To UBound(arr, 1) arr(x, 2) = brackets(CStr(arr(x, 1))) Next x...

I wrote a code to pull a table from a website. The website has a calendar feature and part of the web address can be edited to pull the correct table based on the preferred date. I tried to create a macro that deletes the current table, copies a cell for a new date, opens the code and pastes the...

Hi, I have a problem to be solved. I have data from sheet 2016 and 2017. What I want to do is to make another sheet to calculate the difference money within 2016 and 2017. Please see the image link attached: https://ibb.co/hniZo6 --- case 1 https://ibb.co/jWcuo6 ---- case 2 What I want to do...

Hello, I have a scenario/idea I would like to try but honestly, I am not good enough with VBA to get it done in a reasonable time. I'm aware this isn't a "Code for me" site but I thought I'd describe the scenario as detailed as I can and see if someone can help me or give me an idea of how I...

Whats a simple code for copying columns (A2, B2, C2) from sheet 1 into Cells on sheet 2 (A7, B7, C7) needing this for a macro and adding a command button that just copies it.