marco

  1. mehidy1437

    Adding more column in the arguments in VBA

    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...
  2. H

    MARCO VBA: Del Duplicate Row if match with 3 Col

    Del Duplicate Row if Col A, B, C matched I had thousand row, so possible to use macro?
  3. L

    using variables from other macro

    Hi How can I make the second marco print out the values from the first macro? for example I want to use the second marco to msg out x and y which are variable in first macro. Thank you so much. Sub myinputbox() 'to use msgbox Dim x As Integer Dim y As String x = InputBox("enter...
  4. H

    Macro: Auto Fill down on Col A & B base on cell

    The pic1 show original, and the marco will auto fill down as show in pic2 (yellow)
  5. P

    Copy specific data from Workbook A to Workbook B by a button

    I have set a button to run Marco for the subject action . However, the file name of Workbook A will change every day. I need to correct the file name of Workbook A in Marco before click button. I want to skip the correction step. Please help. Thank you.
  6. K

    Shortening a procedure for VBA

    Hello, I have a macro with VBA for this monthly chart that I make. I have a bunch of repeating lines of code that go for each day of the month but it ended up being too large of a procedure, so it doesn't allow me to execute it. I was wondering if I could get some help to possibly shorten...
  7. E

    Using a value in a cell to name a row

    Hi guys, I want to be able to use a value in a cell to give a ROW a named range name. The reason : I have 500 of them to name. I can easily dynamically pop the name I want for the row in a cell ( in this case I column G). Ideally, I want to write a macro to step through the rows, where it...
  8. A

    How to skip Worksheet_Change?

    Can I skip/disable a sub code before run my marco then recover it like as following: Private Sub progress() Skip run/disable Sub Worksheet_Change(ByVal Target As Range) My Marco Recover/enable Sub Worksheet_Change(ByVal Target As Range) End Sub
  9. O

    Macro/VBA to copy a range of data from a worksheet to a new workbook

    Please,can someone help me write a macro. I have an“A.xls” workbook where I want to open then copy a range of data to “B.xlsx” file. B.xlsxfile has the same format as a.xls so the data being copied will fit the samerange. I then want to password protect the new workbook (B.xlsx) and rename...
  10. C

    Macro needed for Formatting Print Area, Margins etc

    Can someone please help me with possibly an advanced macro. I process a bunch of different reports with different sizes, sometimes single tabs, sometimes multiple tabs, different rows or columns of data and different formatting etc. But every report I send has a few formatting requirements and I...
  11. O

    marco for totalling different length sheets

    I want to record a Marco to total column J and put the total at the end of the list. The difficulty is that I want to use this Marco on lists of various sizes. the curser May be anywhere on the sheet and when Marco is run it should always go to the end of column J. One sheet may be 250 lines and...
  12. H

    VBA for Hidden Worksheets

    Hi, How do you get a marco to work with hidden worksheets?
  13. G

    Call Marco to run from VBA

    Hello, I have written the following code, to copy relevant information into a different workbook, and then run a marco in that book. but it cannot find the Marco, "Macro3" Have I missedsomething? The data has pasted across,jut need t Marco to run. Thak Sheets("summary").Select If...
  14. B

    I have this marco that i need some help with.

    how do I get this marco to stop if there is no value in cell E3. Then let the user know that they must first enter a value in cell E3 before the marco will continue. answer = MsgBox(prompt:="Does CASH IN or CHIPS equalCHIPS OUT", Buttons:=vbYesNo + vbCritical, Title:="Update DaysValues") If...
  15. B

    Help with a marco

    I have a marco that copy's the numbers from A1 and B1. then pastes them on another sheet. I want to write into the marco that if "A1 does not equal B1" the marco stops working until the 2 cells equal each other. thanks in advance for all the help.
  16. U

    Marco to Paste data next to a to blank row

    Hello Mr. Excel members! I am stumped with a Marco need. Here is (what I think) is a similar macro I already have: Sub AddRow5() ' ' Cut_PasteSpecial Macro ' ' Range("C5:S5").Select Selection.Copy Sheets("Presentation for Approval").Select Range("A1:S1").Select lMaxRows...
  17. D

    VBA, search in range of data and then copy and paste

    Hi Guys, I'm working on a extremely tedious project and my hands are about to fall off :help:. So to give you an idea of what I'm doing, check out this GIF: (Note: In the GIF: there are more columns to fill out) So I'm not sure if there is a VBA possible for filling out all of the...
  18. D

    copy tables, then transpose and paste into other sheet.

    hi everyone, I'm not the best in marcos and I've been searching for a solution to this for a while. So what I'm doing is copying a table in a worksheet into another worksheet and transposing it. Some worksheets that contain the original tables can have a lot of tables which is way a marco...
  19. T

    Dynamic map of the netherlands based on colors macro

    Hi, Can somebody help me with this macro? I made the Netherlands with shapes of the provinces. I want each province to get the color based on the range in the second sheet. I already made the file, you can download it with the link in this post I copied the macro of this video...
  20. D

    Excel 2016 - Auto Insert Row with Formula Based on Cell

    Currently have a material tracking workbook which uses a table for organizing. I am hoping someone can help me with producing a code in marco which will insert a new row to "cancel" a specific item by showing the negative value underneath...

Some videos you may like

This Week's Hot Topics

  • Problem with Radio Button's format control
    I am creating an employee evaluation template (a sample is below) Column A is the category Column B, C D, E and F will be ratings (unacceptable...
  • Last Display on userform to a Listbox
    [CODE=vba] lstdisplay.ColumnCount = 15 lstdisplay.RowSource = "A1:O600000" [/CODE] So when i do this it Displays everything on the sheet i am...
  • Rename and move files to a new location
    Dear all, I have an excel file with the following information. The actual file name is at column A but i want to rename it using the following...
  • Help with True/False Formula
    Hello! Am stumped how to fix this formula, in which my result returns 'True', but it should return False. =IF(AG2=True...
  • Clear extra characters from a provided range of cells
    Dear All, I have following code which gives me desired output to remove extra characters from a provided range. But it takes too much time when...
  • Help with Current and highest streaks
    Hi there, I've just joined the forum and this is my first post. I've already spent quite a bit of time searching the net and this forum for a...
Top