selection.copy

Hi all, I've got a large Excel document with about 16 worksheets. Alot of the cells have a colon at the end of the strng, but not all. I need to remove all of the colons sp that my Index Match formulas will work. I've recorded quide a detailed Macro and added the code in to remove the colons as...

Hi All, I am creating a sheet in which I have to select 5 random items out of 20 items. However, if 5 items are selected in round 1, round 2 should have 5 values from the remaining 15 items, round 3 from the remaining 10, and at last the remaining 4. I am using following code but there is an...

I'm needing to consolidate 6 daily worksheets into 1 worksheet. I also need the summary worksheet to be dynamic and update as the daily worksheets are populated. Any suggestions would be great! I've been able to consolidate the worksheets, however the summary worksheets is not updating as data...

Hi everyone, I'm new here (thanks for having me) and am a novice user of Excel. I'm struggling with what I'm sure are basic looping issues in VBA, and am hoping that someone could direct me to a useful instructional website or perhaps be kind enough to help me get started in loops. Some...

Hi, I am trying to copy conditional formatting across each row of a worksheet. So far all I have been able to come up with is recording me manually transferring the formatting row by row. The code ends up looking like this, repeated for every row used...

Hi all, I have the following Macro but want to clean it up, Essentially it inputs a cycle step Number on one sheet then copies the values in a named range and pastes them into a another sheet by selecting a named range. Any help is much appreciated. The code Module is in the following...

when i run the macro i get Unable to set the formular array property of the range class Columns("B:B").Select Selection.Copy Columns("M:M").Select Selection.Insert Shift:=xlToRight Application.CutCopyMode = False Selection.Copy Columns("N:N").Select Selection.Insert...

Any idea why this code wont return to the original workbook? Private Sub CommandButton1_Click() Selection.Offset(1, 0).Select Selection.Copy Workbooks("PromoVendorTemplate.xlsx").Activate ActiveSheet.Paste Destination:=Worksheets("Sheet1").Range("a2") ThisWorkbook.Sheets("April").Activate End...

I'm using the below code to combine all worksheets, however, I only want the visible worksheets to combine, not the hidden ones. How can I change the code to do this? Each sheet has it's own name, right now it combines all sheets from 2 through 16. Sub Combine() Dim J As Integer On Error...

Hi All... new to the forum and pretty new to VBA.. about a week new and looking for some support. I am writing a script to do table comparisons and am stuck on a loop issue. for arguments sake say there are 2 folders with different names and inside the folders there are a number of csv files...

Hi again all, I currently have 4 seperate reports going into 1 main report to give me information i need, i have started doing a macro but this once error shows and im not sure what i can do to solve it. its quite a big sheet.... the debug is highlighted in red. Sub Macro4() ' ' Macro4...

What I need to achieve is as the second column below. I am a noob to VBA so any help will be much appreciated. <code>abc1200 abc1200 MACHINE supplier cost address invoice number abc2400 abc2400 MACHINE supplier cost address...

Hello, I currently have a macro that copies data from several sheets (we'll call these the raw data sheets) to "new raw data" sheets. I am bringing over only the columns I need in to a specific order and I am running into trouble because I have to sort the data and my macro copies from row 2...

Hi Team, Can somebody help to fix the issue. I am trying to copy data from AQ column to AP column with visible cells using cell reference. however it is pasting only "RC[1]" for all the cells of AP Column. Range("$A$1:$BS$20467").AutoFilter Field:=40, Criteria1:="EnterpriseSolutions"...

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

Looking for VBA help to complete this task... Goal is to copy and past from cells into a templet, print a defined area with this information then repeat until there is a blank cell. The macro for doing 1 row of information looks like this... How do I get the macro to loop until there is...

Hi, I am trying to loop through the following macro to work through a range of rows. My goal is to end up with a sheet (Allocation per Employee) populated with the employee department and name and an allocation of time across projects. The Scratch sheet contains a number of formulas that...

Hi, I have a macro that copies and pastes cells from one column to the next to the right. This works fine but does not copy any comments that are attached to the cell, they remain in the original cell. Is there a way to ensure comments move with the cells within the macro? My code is: Sub...

I've read using the SELECT function slows down VBA. Is there an alternative method for the following code: Application.ScreenUpdating = False Application.DisplayAlerts = False Sheets("SAR").Select Range("B62:U62").Select Selection.Copy Range("B63:U121").Select...

I am trying to run the following routines in vba for Excel 2013 I want to insert this equation across all my sheets With ThisWorkbook.Worksheets .Item(1).Range("C29").Formula = "=NGL(+$A$29,+$B$1,+$B$6,+$B$4)" .FillAcrossSheets .Item(1).Range("C29"), xlFillWithAll End With With...