record a macro

  1. M

    VBA Macro help required

    Hi All, I have recorded a macro and need little help in refining it. Please see the code below After the filter It executes this from beneath the header (A1) This is basically (A:F) Range(Selection, Selection.End(xlToRight)).Select Range(Selection, Selection.End(xlDown)).Select (Above...
  2. I

    When Excel macro can't capture steps I carried out

    I'm trying to write some VBA code but I decided to record a macro to help me as a reference. Later I found that Excel can't capture what I had done and I don't know how to write the VBA code to do it. Any suggestions? I've recorded a short video to describe the problem I met and you can watch it...
  3. O

    Excel to record all changes on refresh

    I am NOT the greatest in Excel or VBA. In fact until the last week, I never used VBA, but am learning a lot from Forums and instructional videos. I appreciate everyone of you who participate in these forums and help out those of us who, at times, are utterly and completely lost! I need to...
  4. M

    Help with Record VBA - Copy and paste numbers

    I used the record VBA on this project but the program is not doing everything I need it to do. This is a small sample of a much bigger sheet2 that we’re using. Thank you in advance for any help you can provide. Record output Sub Macro () Range(“D24”).Select ActiveCell.FormulaR1C1 = “6”...
  5. D

    Conditional Formatting in 2 different columns put into a macro

    hello everyone, so I run a macro where I auto-format cells f8:f100 to be conditionally formatted to turn yellow if the D value in the same row is greater than 10,000 and the e column in the same row is greater than 5. The formula is =and(abs(d8)>10000,abs(e8)>5). After this, I do the same...
  6. J

    VBA Regression Help

    The Following code is failing after I recorded a macro of a regression Application.Run "ATPVBAEN.XLAM!Regress", , , False, True, , "", False _ , False, False, False, , False Any help fixing is appreciated! The regression includes labels and the Y data is M11:770 and the X data is...
  7. P

    Automatically paste-link row in one sheet to a new row in another sheet with proper increments

    Hello everyone. I posted this question on another Excel forum last week and no one has responded. :( So here goes nothing... Here at work as a Project Manager, I have been working on redesigning a spreadsheet that tracks the corporation's current projects individually, and displays each...
    • poptart141
    • Thread
    • macro paste-link project management record a macro summary sheet
    • Replies: 1
    • Forum: Excel Questions

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top