=false

  1. 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...
  2. T

    Simplify Recorded Macro

    <colgroup><col style="mso-width-source:userset;mso-width-alt:33901;width:695pt" width="927"> </colgroup><tbody> Hi Dear Members, I have a workbook with ten sheets, one of which is a Total Sheet. I need to extract data from at least eight sheets all from the same range...
  3. 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...
  4. 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...
  5. H

    Runtime 1004 - expected no data error

    Hi All I am applying a filter to a column where sometimes no data will be found (as expected). Can someone help with code to step past the 'Runtime 1004' error so the macro carries on? Thanks Selection.AutoFilter ActiveSheet.Range("$A$1:$Q$2000").AutoFilter Field:=13, Criteria1:=RGB(204 _...
  6. 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...
  7. J

    Run-time error 1004

    Getting this run-time error 1004 and when go debug highlight the the following line of code: ActiveSheet.ExportAsFixedFormat Type:=xlTypePDF, Filename:=PDFFile, Quality:=xlQualityStandard, IncludeDocProperties:=True, IgnorePrintAreas _ :=False, OpenAfterPublish:=OpenPDFAfterCreating...
  8. 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...
  9. M

    Excluding worksheets from a Macro

    Hi there - bit of an Excel novice, but trying to get a Macro I have on a document updated so it ignores a few of the worksheets. The sheets to be ignored are just data, and the macro in question is a simple copy & paste job for some monthly tabs we have further in the document. Have tried to set...
  10. 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...
  11. M

    Excel VBA - Find merged cells in column and add a formula

    Hello, I am trying to figure out why this code is not working. I need to find merged cells in column AX. Once these merged cells arefound I need to use the following vba formula to copy the value. What am Idoing wrong? 'Select Merged cells in column AX and add header based on...
  12. M

    Excel VBA - Extracting Data from Another File

    Hello, I am having an issue figuring this out. I have the below code that will open afile based on certain dates. Since the file names have varying dates everymonth I created variables that will open the correct file based on the dates incertain cells. Cells A15 and A16 have the actual dates...
  13. gheyman

    Stop a VBA Code error

    This code uses GetOpenFilename and opens up a file window so that the user can select a Workbook The problem I am having is when a user changes their mind and doesn't select a workbook. If this happens the user gets a Run-time error which I never want to happen. How do I stop this from...
  14. D

    Populating and Clearing Fields with a Check Box

    Hi, I am trying to populate and clear fields using a check box. I have written something long and stupid that will not work. Can someone help me. This is what I have: If Sheets("MISC DATA").Range("C18").Value = "TRUE" Then Range("F5:N5").Select Selection.Copy...
  15. gheyman

    Simple copy paste VBA not working - Help Please

    This code is supposed to be a simple copy some columns from one tab and paste them on another. It appears to be functioning, but no values are being pasted. Private Sub CommandButton1_Click() ' ' To unprotect sheet without password ActiveSheet.Unprotect ' Copy Over Columns...
  16. G

    memory leak?

    I've been using the following code for a few years to flip spreadsheet data around without issue. Recently however I received a large data set (about 5X larger than those I typically work with and the macro eventually runs out of resources and stops. Typically this runs instantly. I've tried...
  17. F

    Just start today learn VBA

    Hi I want to past a data to another file using macro without any duplication this below is past without considering any duplication Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _ :=False, Transpose:=False ActiveWindow.Close savechanges:=True...
  18. M

    Specify Current worksheet in a Macro

    Hello everyone! I'm trying to automate the copy process of a certain Sheet to another Sheet in order to create a sum up of a day in my company. So: I have a workbook with 32 Sheets. 31 Sheets for each day of the month. 1 Sheet that works as a "template" to sum up the data of each day. All...
  19. T

    VBA - Extracting Data to another sheet (Need help simplifying vba)

    Hello! My macro below works. However, I believe it's not efficient. Is there a way this can be written to make it more efficient? I basically Frankenstein'd this from other macros, but surprising it works. What this does is it extract months that are in columns to rows and insert the...
  20. J

    APPCRASH caused by VB code when saving

    Hello all, I have a workbook that is intermittently crashing when saving or when trying to just close the workbook. At other times I get the crash when opening the VB editor. This workbook lives on a network share as it's used by a few people, but at different times. It will occasionally crash...

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