transpose=false

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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