rows11.select

  1. A

    Copy all sheets (sheet1, sheet2 etc to 9) and paste to sheet "Master"

    Hello all, i want to find out if there is a better way to copy from sheets1 through 9 and paste to sheet "master" one sheet below the other. here is the code i have cobbled together which does work but maybe there is a more efficient way? ' select the range to copy and paste to "master"...
    • andymalan
    • Thread
    • false rows11.select selection.copy selection.insert sheetsmaster.select
    • Replies: 12
    • Forum: Excel Questions
  2. M

    How to edit Macro to ensure print area and streamline

    I have been growing more and more comfortable with Excel in my new position and really enjoy learning how to work more efficiently with it. Recently I have been filling in for someone on long term disability and I have to extract data from AVANTIS to an existing Macro every week that we use to...
    • MacroJoe
    • Thread
    • backlog.select cells.select rows11.select selection.autofilter sheetstotal
    • Replies: 0
    • Forum: Excel Questions
  3. O

    Simplify the code, write everything in less than 20 lines

    Hi Everyone, i was wondering if this code Range("A1").EntireRow.Copy Sheets.Add After:=ActiveSheet ActiveSheet.Name = "Pending" ActiveSheet.Paste Cells.EntireColumn.AutoFit Sheets.Add After:=ActiveSheet ActiveSheet.Name = "Closed" Worksheets("Sursa").Select Rows("1:1").Select...
    • Ossian13
    • Thread
    • activesheet.name activesheet.paste after=activesheet rows11.select sheets.add
    • Replies: 3
    • Forum: Excel Questions
  4. E

    Copy rows based on char length

    Hello, I need help with macro to copy rows to new sheet based on length. if cell in column J has 9 or 14 characters than copy entire row to new sheet. I have something like this for another column and that is working but now I need length for another...
  5. crystalneedshelpplzthnx

    Inserting a formula not working correctly

    Hi All, I have been searching and changing this code and nothing has worked. I have been running the code after copying the formula as a work around. Can anyone explain what it is I am doing incorrectly. Ive tried the following: Sub Key_Items_Validation1() Sheets("ProductivityData MTD").Select...

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