vba excel

  1. N

    How to keep the validation List available even after paste

    I have a cell has a list countries , when I paste data, this cell will have a new information but the list will be disappeared ! how can I keep the country List available even after paste . Regards
  2. E

    Run a Macro based on a cell value

    I have a summary tab where i want to run macros depending on what is selected in a drop down list to compare two other data tabs. The data tabs are called 'A', 'B', 'C', 'D', 'E' and 'F', and the data in each tab is in the same cells and format, just different values. I want to have two drop...
  3. E

    Format the selected series in Chart in Powerpoint

    I would like to create the macro which will format the selected "DATA LABELS" in chart in powerpoint. Below is my code. But the problem is Im not able to write code for selected "Data Labels". Please assist Sub testSelection2() Dim shp As Shape Dim count As Integer Dim left_count As Double...
  4. M

    Copied Date Data is NOT a Number

    Hi, How do I copy date data retaining its number format? Dim Sourceworkbook1 As Workbook Set Sourceworkbook1 = Workbooks.Open("[File path & name]") Application.ScreenUpdating = False Sourceworkbook1.Sheets("[tab name]").Copy After:=ThisWorkbook.Sheets("[tabname]") I have written a matching...
  5. Z

    Copy and paste

    Hello, I am trying to copy a block of lines (the red one for ex) from a source sheet to another sheet using a button to show a userform and then choose specific elements. The source data are: Well, in my userform I have to choose the test, number of test, Week and year: and then the...
  6. L

    VBA Excel, group rows and perform an action for each group

    Hello! I have an excel like this: So I have column A, I want column B to complete automatically. I though that by entering a blank row between groups it will be easier to separate groups. So it will go down the column A and for each not empty row it will write Iph in column B, when it finds...
  7. S

    Copy Specific Sheet of multiple workbook to multiple sheets of another workbook

    The below VBA code breaks if the name of the workbook or there is no workbook exist. In my case, the VBA code breaks on opening workbook wbR4 due to difference in name and the code stops there itself and not proceeds to next workbook. The code is about to copy specific sheet of source workbook...
  8. Z

    Duplicates items in a listbox

    Hello, I am new in VBA programming, I have data on an excel worksheet in column A cells(23,i) and A celles(24,i) ordered like this I want to show the data in a listbox without duplicates and showing only recent dates for each value (N IT) like this: To show the list I created a button, and...
  9. L

    Active cell value in other Worksheet selected and marked

    Hello community, I try to create a macro which helps me find the value of a cell in other open worksheets. I have the value of the active cell in worksheet "KS" and i want to get the cell with the same value from worksheet "BGF" selected. If possible both cells get hightlighted with red...
  10. P

    VBA code to download zip and extract csv file from it and save with specified name

    I am having a simple application in excel to download all zip urls in column "C" column "C" has urls and column "Q" has names Every url has 1 zip file and every zip has 1 csv in it. What I want to do is to 1. unzip the CSV files and save them with names as mentioned in column "Q" 2. Kill all the...
  11. N

    Calculating Percentage difference VBA Excel facing RunTime Error 91!

    While the percentage difference works for current month vs previous monthly, and vs previous year without issues for the 40 +sheets within the workbook, i experience runtime error 91 when using current month vs closest quarterly number calculation. Attached is the screenshot for reference. I'm...
  12. M

    Looping through Worksheets in Workbook while looking for specific text

    Working on a macro that will loop through Workbooks in a folder. Within each workbook it will loop through all the sheets looking for a specific string of text. In this case "*Labor*". My sample workbooks, has 3 sheets with "Labor" in the WS name). Once it finds a match the macro will copy and...
  13. K

    VBA Reference Unsaved Files

    Hello, This is probably a quick fix but for the life of me I cannot figure it out. I have a project that references an open unsaved file ("Invoice Data.xlsx"). Every day a new file is emailed to us with invoicing information. The macro file imports the relevant data and runs some calculations...
  14. T

    compare and Extract unique values between 2 columns

    Hello All I am trying to create a macro that will Compare data in two columns (on two sheets (sheet1 Column B, sheet2 Column A) and add any missing unique values from sheet 1 to sheet 2 Sheet1 column B Items#s Item 1 Item 2 Item 1 Item 4 Item 1 Item 2 Item 3 Item 4 Item 5 Item 6 Sheet2...
  15. B

    Specific data from a table added to email Subject through using VBA

    Good morning all, As ever I am stuck and need some help, I have my email function working and I am successfully adding an attachment also, however i have a % of inspections completed located in a table that i need to be part of the email, preferably in the subject?
  16. B

    VBA Add Worksheet to an email?

    Good afternoon all, Is there an easyish way to add a worksheet to an email! This is the code I have already, i want to add a certain worksheet! 'it is set to .Display so the email can be checked before it is sent Sub InspectionEmail(Names As String) Dim OutApp As Object ' holder for outlook...
  17. G

    System Error &H8000FFF (-247418113). Catastrophic failure

    I have now twice had this error, where I email a spreadsheet with macros to another person. It is working when I send it using share via email. When they get it there is a problem. When I go and open the original, I also get the problem. System Error &H8000FFF (-247418113). Catastrophic failure...
  18. V

    Is there any way to change range's values more efficiently than looping?

    I have a range of cells with values inside. The values have pattern such as '123-abc'. Now I need to change the value of selection to just 123. I currently use left function to loop over the selection. But it's very slow because I have 1000 cells.
  19. S

    vba code exact match string

    Below is the beginning of my code, the only issue I'm having is that the below list when deleting should only delete on an exact match. So for example if I have 'carrier name' as a column header and 'carrier name 2' as a column header by the list below only carrier name column should be...
  20. M

    Help with VBA project multiple tasks

    Hi, I’m hoping someone could help me with the tasks below; I know it’s a lot but Any help would be much appreciated. (#1-8 order matters) 1) in column AA SheetA any “0” change to blank cell 2) column AC SheetA some cells say “Fired - xxxx” , I’d like to change anything that doesn’t start with...

Some videos you may like

This Week's Hot Topics

  • Problem in vba vlookup
    Dear All Master, The problem I mean is as follows : 1. I want to modify the vba code because it takes too long/very slow to vlookup in VBA code...
  • VBA Vlookup
    Please for help. Why it`s not works? [CODE=vba]Sub Check_equpment1_click() Worksheets("Production_program").Activate Dim ans1 As Integer ans1 =...
  • Nesting INDEX MATCH into SUMIFS
    I currently have several formulas pulling in a SUMIFS from a data sheet, beginning with =SUMIFS('datasheet'!$N:$N, 'datasheet..... but as I am...
  • Extracting number from a range randomly
    Hello Expert, please kindly advise what is the best method to extract numbers from a range randomly I have a series of numbers in the range of A1...
  • Problem with If Formula
    I am using the following formula in cell A5. I would like if N5 is blank then A5 also return blank. If N5 is 0 or is greater than zero then equals...
  • Is there a way to make the day's name show up automatically in a header?
    I have a form I print out every day..and in the top right custom header I have the &[DATE], which automatically gives the current date in top...
Top