=false

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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