Advertisement
Guest User

Untitled

a guest
Jun 20th, 2019
64
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.52 KB | None | 0 0
  1. Sub Cement()
  2. Dim cell As Range
  3. Dim selRange As Range
  4.  
  5. For Each cell In Range("L5:AJ370")
  6. If cell.DisplayFormat.Interior.Color <> cell.Interior.Color Then
  7. If selRange Is Nothing Then
  8. Set selRange = cell
  9. Else
  10. Set selRange = Union(selRange, cell)
  11. selRange.Copy
  12.  
  13. End If
  14. End If
  15. Next
  16.  
  17. If Not selRange Is Nothing Then selRange.Select
  18. Range("L5:AJ5").Select
  19. Selection.PasteSpecial xlPasteValues
  20. End Sub
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement