Results 1 to 6 of 6

Move column - Used Find function

Threaded View

  1. #1
    Registered User
    Join Date
    02-07-2019
    Location
    New Delhi
    MS-Off Ver
    MS Office 365
    Posts
    84

    Move column - Used Find function

    Hello sir/ma'am,

    I need to cut the column I [0-15] and paste it to column b by inserting a new column.

    I tried with:

    columns("i").cut
    columns("b").insert

    But, the agebucket column "0-15" keeps changes on daily basis depending on received ageing. I also tried with find function, but it is giving me an error:

    Range("b2:b7").Find(what:="0-15", MatchCase:=True, lookat:=xlWhole).Select

    Please help

    Regards,
    Manish
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Find Last Cell And Move to New Column
    By bluemanuk1 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-20-2021, 01:30 PM
  2. [SOLVED] Find certain Text in a column then move those cells back 1 column
    By Grahamfeeley in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 06-11-2017, 02:15 AM
  3. Find the last used cell in a row and move to a column in the same row - Move to next row
    By usafmeinweg in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-14-2015, 02:42 AM
  4. Find Text in Column then Move
    By Grahamfeeley in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-28-2014, 04:34 PM
  5. Find Text in Column then Move
    By Grahamfeeley in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 05-28-2014, 02:44 AM
  6. [SOLVED] VBA to find data in one column and move it to another column
    By toneill in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 08-13-2013, 08:44 AM
  7. [SOLVED] find and move data within a column
    By Craig in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-24-2006, 02:20 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1