Why is my code so inefficient?

[Lucy89]

The following code takes an age! It does work but takes a very long time.

Any help please

Sub Copy_Paste_Filtered_Selections()'
' Macro3 Macro
'


'
    Sheets("Selections").Select
    Range("A26:AO124").Copy Sheets("Filtered Selections").Range("A10000").End(xlUp).Offset(2, 0)
        
End Sub

 

[MARK858]

Happy you worked it out. For me I only use colors to emphasise important cells so my sheets are always low on any colors let alone conditional formatting.

As for the conditional formatting issues perhaps the links below will explain more...

Exploring Conditional Format Performance Part 1: What’s slow, whats buggy and whats faster! | Excel and UDF Performance Stuff
Exploring Conditional Format Performance Part 2: What’s slow, whats buggy and whats faster! | Excel and UDF Performance Stuff
Exploring Conditional Format Performance Part 3: What’s slow, whats buggy and whats faster! | Excel and UDF Performance Stuff

 

[Lucy89]

Thanks Mark

L x