cells.select

I have some code that is filtered on a column, copying the visible rows, going to a new sheet, and pasting the code down. It works, but its incredibly slow, is there a faster way to generate this block of code? Selection.AutoFilter ActiveSheet.Range("A:J").AutoFilter Field:=3...

Hi guys- I am running this code on a document with ~ 25,000 rows by66 columns wide. This code right now is taking around 45 seconds to 55 seconds to run, and sometimes I get the (not responding) and it takes over a minute. I was wondering what steps in my code could be adjusted to run faster...

Hello, I have been told to many Select and copy and paste commands can slow down my code. What would be a faster way of doing this? - It is copying the filtered results to a new Sheet called filtered. Sub Filtered() ' '~~~~ This macro adds the filtered sheet to begin the report process '...

Hi Team, I have recorded below macro i want to select previous day date and delete all the records but the date remains same when the macro was recorded, Please could you help me with the code to delete previous day records in column X1 and their associated rows Thanks...

I am trying to use VBA to trim and clean up all data on a worksheet. I would like to remove leading, trailing, and any extra intral spaces. Below is the code that I am trying to use, but it will not work. I am using cells.select to select all data on the worksheet. If I remove that line and...

I have been growing more and more comfortable with Excel in my new position and really enjoy learning how to work more efficiently with it. Recently I have been filling in for someone on long term disability and I have to extract data from AVANTIS to an existing Macro every week that we use to...

I've got around 50 wb's I'm currently updating using vba. But It'a a drag writing (and updating) the same code 50 times, so I'm trying to come up with a way to re-use code. The code below got a lot of unnecessary code (Activate, Select), but I can change that later. What's important is if what...

Here are my two issues: 1. I am having a hard time figuring out this "Debug." I copy and pasted the code below. It has two do with an image I inserted in the Macro then hyperlinked it to a website 2. I added a sheet by mistake then deleted it. Every time I run the Macro it pops up "Are you sure...

The code below is run from ThisWorkbook. It opens another 4 wb's (Gr1.xlsm, Report1.xls, Report2.xls and Report3.xls), and copies data from wb Report 1-3 into 3 different sheets in wb Gr1. Vba works, but I'm looking for a better way of writing it. One issue is to avoid as much use of .activate...

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

I've been working on this macro most of day and when I finally get it basically work towards the end I get a run-time error 424 "Object Req." when I am selecting the entire work sheet (cells.select) before I do a replace. I must be missing something simple because I can't figure what DIM for...

Hi All, I'm trying to run the below macro (recorded) however it stops before it gets to "Rows("1:8").Select" It also paste special values columns AF & AG which I don't want it to do. I've been trying for hours and almost given up hope! Any help is greatly appreciated. Thanks, Wes...

Hi Currently using the following vba to copy from one workbook to another, however, this copies with no text formatting. Some of the text is grey, red or blue and I need to copy that over. But not copying the cell Fill format. Had a search with no luck. Help appreciated. Sub...