1. D

    Using Selection.Copy to transfer data to another sheet, starting from column C

    Hi all, This might be a silly question but i am new at VBA so can't seem to figure out what the error in my code it. I have two sheets, sht1 and sht2, from which a user is to highlight the row to transfer sht2 from the next empty row and starting from column C. My code is as follows Sub...
  2. V

    Loop required for a macro

    Hi, Please check the following macro code and advice how can we run it in loop, Sub Loop() ' ' Loop Macro ' Range("D2:D8").Select Selection.Copy Range("E8").Select ActiveSheet.Paste Application.CutCopyMode = False Range("F2:F8").Select Selection.Copy...
  3. C

    VBA SaveAs Error

    Hello, I am trying to automate some data importing into a spreadsheet from another then save as a new file name. When I go through the macro it all works right up to the point it trys to save the spreadsheet. I just get the run time error 424: Object required I am sure I must be missing...
  4. A

    Filtering by variable criteria, then copy-paste the data

    Hi! I need to Filter An array of data by a criteria(emails), then the filtered results has to be pasted in other sheet, at a specific row(the row corresponding to each email address), but if there are two or many rows that has to be pasted, excel has to add the additional rows in the sheet. I...
  5. E

    Simplifying Code Efficiently

    Hi All, i have written a code that looks quite repetitive and could probably be structured much easier with a loop / case, however i'm struggling to apply a proper form. I've highlighted the only difference in bold. Could you kindly have a look at my code below (it's an extract, the code...
  6. A

    Copy/Paste and remove duplicates

    Hi all I have done a macro to copy data from sheet2 to sheet 3 then remove duplicates, however it doesn't work, please could anyone help? Sub Reconcile() Dim LastRow AsLong LastRow =Range("A" & Rows.Count).End(xlUp).Row Sheet2.Select Range("F2:F" & LastRow).Select...
  7. willow1985

    VBA for verifying whether a specific worksheet and cell have data or not

    Hello, I believe I am looking for a very simple VBA code but am not sure because of how my current Macro is structured. During one point while my macro is running it checks a certain cell (B16) and if it is blank it will issue a message, "No Results" and will end sub. If there is results it...
  8. willow1985

    Macro code keeps getting hung up

    Hello, I have the below code that used to run fine but now it seems to be getting hung up and excel now freezes and the macro does not complete. Any idea what could be causing this? Thank you Application.ScreenUpdating = False Application.Calculation = xlCalculationManual...
  9. M

    Paste several worksheets into one worksheet

    I used to have this working but then we made changes. Can you help me? this macro opens up and pastes each sheet into one sheet. Sub Aisles() ' ' Aisles Macro ' ' ActiveWindow.ScrollRow = 50 ActiveWindow.ScrollRow = 48 ActiveWindow.ScrollRow = 46 ActiveWindow.ScrollRow = 43...
  10. V

    VBA Code Editing Help

    Thanks in advance, i have the following VBA code, Its o.k. no change required Range("IX10").Select ActiveCell.FormulaR1C1 = _ "=IF(AND(RC[-253]=""Na"",R[1]C[-253]=""Yes""),COUNTIF(R2C[-253]:RC[-253],""Na"")-SUM(R1C:R[-1]C),"""")" Range("IX10").Select Selection.Copy...
  11. M

    tidy vba

    Hi ive recorded a macro to transpose a cell contain text and then use in a validation. The code works fine but is really messy and i would just like to tidy it up. Wonder if there is any other code that would be more beneficial. Thanks in advance MC Code: Sub Macro3() ' ' Macro3 Macro ' '...
  12. S

    Macro Fill Down Not working

    Hello, I have the macro below. I have fill down in two columns but for some reason, it is not filling down to last row. It stops at row 71 even though there are 94 rows of data. The # of rows vary week to week so the last row # can't be static. I have pasted the macro below. I am having...
  13. S

    Copy Multiple Workbooks into One

    Hello, I need to write the VBA code make this easy. Range of A1:AN81 will put into or copy at the Range A+81. They are in the same folder. Thanks in advance. Please see the code below. Sub CopyPasteMultipleWorkbooks() Workbooks.Open Filename:= _ "G:\My Drive\2018-2019 SF1\Grade...
  14. T

    Copy row based on data validation value in cells in specific column

    Hello everybody. I am wet behind the ears with VBA/macro's in excel. I have a spreadsheet that I use to input information, but I want to copy specific rows from that "active" sheet to other sheets based on the values in the cells of colume"b". The rows will be copied to different sheets based...
  15. E

    VBA: Copy All Data Including Filtered Cells From Table

    Hello All, I'm copying information from a table on the server and pasting the data onto another workbook. The problem is the table is always being filtered so when the macro runs it pastes the visible data only and not the entire table. Any help would be appreciated, thank you in advance, -E...
  16. D

    Follow up question on VBA coding for Top 5 Customers.

    I have a followup question to an earlier post. The formulas are all working great. However, I need for the coding to overlook 3 customers when selecting the "Top 5 Customers". These customers are GMIT, BGS GRM, and GMIT SC. I'm not sure how to incorporate this into what I have currently...
  17. T

    Simpler Macro required

    Afternoon All, I have the following Macro for the sample Table below. I would like the Macro to loop until it reaches the end of the table, at the moment i have the shortcut entered at the end but this requires me to be infront of the computer at all times to end the macro by pressing ESC...
  18. M

    VBA Copy columns from one sheet to another

    Hi, I have a probably very frightening piece of code below. It does the trick but is clunky I know. I just don't have the know how to streamline. Its a very simple request I'm sure... Copy columns from one sheet based on table headers in to another based on table headers (they are the same...
  19. DataBlake

    Using Range & Rowscount

    Dim lastRow As Long destrow = Sheets("Master Wheel").Range("A" & Rows.Count).End(xlUp).Row Columns("T:T").Select Selection.Insert Shift:=xlToRight, CopyOrigin:=xlFormatFromLeftOrAbove Range("T2").Select ActiveCell.FormulaR1C1 = _ "=IF(ISERROR(VLOOKUP(RC[-19],'Master...
  20. J

    VBA to increase cell value by 1 and loop code

    Hi all, I have the code below that works as needed, but I'm looking at enhancing it further. I want run the code below, and then have cell F5 increase by 1 and then rerun the code below. I want to do this until F5 hits 40. Appreciate any help and assistance. Range("P8").Select...

Watch MrExcel Video

This Week's Hot Topics

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
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 "".
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