View Single Post
 
Old 11-21-2023, 04:50 PM
Alansidman's Avatar
Alansidman Alansidman is offline Windows 11 Office 2021
עַם יִשְׂרָאֵל חַי
 
Join Date: Apr 2019
Location: Steamboat Springs
Posts: 115
Alansidman has a spectacular aura aboutAlansidman has a spectacular aura aboutAlansidman has a spectacular aura about
Default

VBA Solution
Code:
Option Explicit

Sub delcontrol()
    Application.ScreenUpdating = False
    Dim c As Range, rng As Range
    Dim lr As Long, lr2 As Long
    lr = Range("A" & Rows.Count).End(xlUp).Row
    Set rng = Range("A2:A" & lr)
    For Each c In rng
        If InStr(c, "control") > 0 Then
            lr2 = Range("C" & Rows.Count).End(xlUp).Row + 1
            c.Copy Range("C" & lr2)
        End If
    Next c
    Application.ScreenUpdating = True
    Application.CutCopyMode = False
    MsgBox "Action Completed"

End Sub
__________________
Alan עַם יִשְׂרָאֵל חַ Using O365 v2510
Reply With Quote