+ Reply to Thread
Results 1 to 4 of 4

How to Delete entire column in Excel finding with "=" special character by using VBA code.

  1. 09-07-2022, 11:53 AM #1
    rexysri
    rexysri is offline
    Registered User
    Join Date
    12-16-2020
    Location
    hyderabad
    MS-Off Ver
    office 365
    Posts
    10

    How to Delete entire column in Excel finding with "=" special character by using VBA code.

    Hello friends i need VBA code. that find the = in entire column and delete entire rows.
    A
    1
    2
    3
    4
    5
    ===
    ===
    ===
    Reply With QuoteRegister To Reply
  2. 09-07-2022, 01:34 PM #2
    oeldere
    oeldere is offline
    Forum Expert
    Join Date
    05-30-2012
    Location
    The Netherlands
    MS-Off Ver
    Office 365
    Posts
    14,987

    Re: How to Delete entire column in Excel finding with "=" special character by using VBA c

    Why not filter on column A and filter on =.

    After that you can delete the rows.
    Notice my main language is not English.

    I appreciate it, if you reply on my solution.

    If you are satisfied with the solution, please mark the question solved.

    You can add reputation by clicking on the star * add reputation.
    Reply With QuoteRegister To Reply
  3. 09-08-2022, 02:12 AM #3
    rexysri
    rexysri is offline
    Registered User
    Join Date
    12-16-2020
    Location
    hyderabad
    MS-Off Ver
    office 365
    Posts
    10

    Re: How to Delete entire column in Excel finding with "=" special character by using VBA c

    Dear Brother i need a VBA Code for my daily use work to do many files like this so requesting VBA Code please post it
    Reply With QuoteRegister To Reply
  4. 09-08-2022, 02:30 AM #4
    oeldere
    oeldere is offline
    Forum Expert
    Join Date
    05-30-2012
    Location
    The Netherlands
    MS-Off Ver
    Office 365
    Posts
    14,987

    Re: How to Delete entire column in Excel finding with "=" special character by using VBA c 

    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Extract Data from Column, which contain character "/" and in Left side of character "-"
    By ionelz in forum Excel General
    Replies: 14
    Last Post: 03-01-2021, 10:04 AM
  2. [SOLVED] Extract Data from Column, which contain character "/" and in Left side of character "-"
    By ionelz in forum Excel General
    Replies: 14
    Last Post: 05-11-2020, 07:47 AM
  3. if a cell in column P contains "12345" then delete entire row
    By justlearning123 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-19-2015, 10:55 AM
  4. [SOLVED] Faster code to delete character "#"
    By Villalobos in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-01-2015, 04:26 AM
  5. Delete entire column if word "False" exists
    By mikey3580 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 04-09-2014, 02:33 PM
  6. [SOLVED] How to put special character "&" in Excel Header / Footer ?
    By Phiews in forum Excel General
    Replies: 1
    Last Post: 01-11-2006, 05:15 AM
  7. Disabling "Entire &row/&column" in Delete/Insert Cell
    By Gap in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-06-2005, 12:06 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1