transpose=false

  1. S

    Combine two vba code snippets

    Hello all, I have a rather big area (A1:CJ311) with some cells having Borders on all sides, some cells collectively have a thick box border etc. Most of the cells have formulae in them. I want to copy the whole range("A1:CJ311") to another location with just the bordering formats of the cells...
  2. T

    Change date format

    In Work sheet figures there is a date usually a day before in this format 15/08/2019. I have a simple macro see below is there a way of closing the work book but with the date as 15.08.2019 using the path T:\11 Admin support etc as the target automatically Sheets("Figures").Select...
  3. imback2nite

    Worksheet Deactivate

    I'm trying to get a handle on 'Deactivate'. My biggest problem are the users that forget to update the worksheet. I've been using the Command button and here is the code. It works but only when the users hit it. Sigh... Private Sub CommandButton2_Click() Application.ScreenUpdating = False...
  4. R

    VBA to copy and past based on a dynamic range

    Hello All Experts, I have a standard template column A-D and variable value column G-H. I would like to copy and past a variable value into a standard template then repeat it until the last row of variable value. After some searching within the board, I could came up with below codes but...
  5. 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...
  6. D

    Copy Pasting a lot of data using ActiveCell Offset

    Hi Below is some code I have. There's actually a lot of copying and pasting going on between workbooks (more than I show below). I would like to speed up the macro and was wondering is there better faster way to copy paste a number of cells on a worksheet that have been identified with a...
  7. E

    Macro/VBA Paste Data Below the Last Used Row

    Hello Everyone, I have 5 tabs in total in my workbook, when I click on the macro button I want to clear the information from the dashboard and then bring in the information from the other tabs onto the Dashboard tab. So the problem i'm having is when I bring in the information from the second...
  8. T

    Macro works from VBA UI, but not when assigned to a button

    Hi, I am having an issue with the code below. I am able to hit the run button in the VBA UI, and the macro works perfectly, but when I assign the macro to a button, it errors out. "Run-time error '1004': Method 'Range' of object '_Worksheet' failed. Any help would be much appreciated. Thank you...
  9. W

    How to make this excel macro repeat on the next line until there is no more Data in column A?

    am fairly new to VBA what i am hopping to do is to make this macro recording code repeat this on the Cell 1 then Cell 2 Then Cell 3 until there is no more data fields left in the A col. Basically its supposed to copy a Cell in A1 and copy to book 2 then hit refresh data then copy some Info back...
  10. gheyman

    Code that only works when it is run from a certain tab

    I have code tied to a userform (on the form I have a run button which runs the code). If I launch the Userform from one tab, the code runs great. If I launch the Userform (via a button) from another tab it errors out. (run-time error'1004': Select method of range class failed) It errors on...
  11. R

    Stepping through this macro works perfectly, but I get a runtime error every time I run it.

    Hello all, the "problem area" is highlighted in Bold. We've tried extensively to fix this including aliasing all sheets and variants of "ActiveWorkbook.Activate" Sub Produce_Report()' ' Produce_Report Macro ' ' Application.ScreenUpdating = False Application.Calculation = xlManual Dim F...
  12. D

    VBA - Paste Special

    I have a macro, and at the end of it, I'd like to copy my selection and paste the data right where it is, but paste values only. I have this code: Range("J4:Y4").Select Range(Selection, Selection.End(xlDown)).Select Selection.Copy 'Range("J4").PasteSpecial Paste:=x1PasteValues...
  13. A

    Macro/VBA trouble

    Hi, I am working trying to create a macro that will populate different worksheets based on a value in the dropdown selected in the tab called "List". I need the Macro to loop through all the values in the dropdown and populate different tabs based on the value. The name of the tab corresponds...
  14. B

    Macro email error

    Hello, after i upgraded my PC from outlook2016 to 365(the app version), the following macro didn't create email anymore. PS, if i disable the excel attachment the simptom disapers!!! thanks in advance MAcro... Sub Save_and_PDF_online() Dim WB1 As Workbook Dim WB2 As Workbook...
  15. M

    Macro runs slow on superior computer

    I have a macro, it's not an especially well written macro, but it works. It involves a lot of copy and pasting within a spreadsheet with lots of necessary COUNTIFand INDEX/MATCH formulas. I run the macro at work and at home on my new computer. The thing is, this macro runs, literally, twice as...
  16. M

    Run-time error "2147417848 (80010108)': HELP!!!

    I Started to get this error lately when running a macro. I seem to get it when I run multiple instances of excel to run at the same time (10 at the same time). MESSAGE BOX Run-time error "2147417848 (80010108)':<strike></strike> Automation error The object invoked has disconnected from it's...
  17. R

    Index/Match Macro.

    Hello, I am trying to write a code that will do the following: - Search column A in sheet2 for a match to ABC in the code provided. - if there is a match in column A then select the value in column B of the corresponding row - The value in column B to be use as an additional name in the new...
  18. R

    Rename New Workbook Based on Condition from other Sheet

    Hi, i already code some script for renaming the new workbook. But i have trouble to rename it based on condition. Here's the code that i scripted. I've been using this code for a long time. But now i need to put additional condition. Here's what i'm looking for: 1. Insert an additional name in...
  19. J

    Filtering and copying a sheet to another sheet... not working as planned!

    Morning all, I'm trying to filter a sheet and then copy the filtered data to another sheet. What I've got below works but it balloons the size of the workbook up to 180Mb! I'm assuming it's because I'm copying the entire columns rather than just the filtered data...? Any thoughts on a better...
  20. V

    Need code to be Shorten

    can any one please shorten this code in professional way please.. Sub datacollect() Application.ScreenUpdating = False Application.DisplayAlerts = False Sheets("Surety").Visible = True Sheets("Lossrun").Visible = True Sheets("OPT").Visible = True Surety...

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