0.select

Hi guys, the following macro seems to run a little slow, is there anyway of making the code more efficient / run faster ? Sub Adjust() ' ' Adjust Macro ' ' Keyboard Shortcut: Ctrl+a ' Dim lr1 As Long Dim lr2 As Long Application.ScreenUpdating = False Range("A2:AQ" &...

I am new to VBA, but I have been able to edit my recording enough to get what I want to this point. Here is what I have so far: ActiveCell.Offset(-12, 0).Select Range(ActiveCell, ActiveCell.Offset(0, 16)).Select Selection.Copy ActiveCell.Offset(12, 0).Select ActiveSheet.Paste...

I have the following set of commands/code in a macro that can be run on different spreadsheets. How can if make the macro skip the set of commands to the next group if the value is not found, i.e. if the "0243" is not in the spreadsheet I want the macro to next group command and try to find the...

Hi all, Sorry to bother people with this, but I cannot seem to find what keeps crashing Excel in the following code. I already know the code is horrendous to look at as i'm not amazing at this, so if anyone could provide tips on keeping it efficient that would be awesome too. Private Sub...

Is there a way to offeset the cell selection without using .select? I have a macro that requires a lot of cell offsetting as it runs, but the .select commands are slowing things down to much. I've read a lot about ways to remove .select, but with all the copying and pasting this macro does I...

I have the following code - (some sensitive information replaced by the word info) which works fine when each subtotal group has several entries, but falls over when there is only one entry. Could someone please help me out. The part of the code where is it specially giving me the 1004 error...

On my worksheet I use five ranges for data measurements as follows B6:B35, D6:D35, F6:F35, H6:H35 and J6:J35. sht and ac are used to call the sub and the default value of ac in this case is "B6". The code below is supposed to scan through each range until it finds the next available empty...