This will add the code formatting to your post, making it easier to read.
Hi, I have the code below with the usual Application. Using the sheet code will ensure that the code will always work. Sheet17 is the sheet that Macro41 works in, the code is below...
Paste Special Paste:=xl Paste Values, Operation:=xl None, Skip Blanks _ :=False, Transpose:=False Application. Replace What:="zz", Replacement:="", Look At:=xl Part, _ Search Order:=xl By Rows, Match Case:=False, Search Format:=False, _ Replace Format:=False ws.
Range( _ "AH6: AH" & lrow), Sort On:=xl Sort On Values, Order:=xl Ascending, Data Option:= _ xl Sort Normal With ws.
This means that the Excel screen can look like it has "gone crazy" while the macro is running.
One thing you may want to do with your macro to make it run faster and to prevent distracting flashes on the screen is to turn off screen updating while the macro is running.
Screen Updating = True THe error is Compile error, Method or data member not found Anyone has a clue what the problem is?
Add 4 spaces to the beginning of each line of the VBA code or indent the code in the VBA window and paste it in.
Screen Updating) are returning an error: Application.
Screen Updating = True err Handle: End Sub You are right, there's always a better solution than using the Select command which can have side effects.