Results 1 to 8 of 8

Find last data and perform insert column

Threaded View

emina002 Find last data and perform... 05-24-2012, 10:34 PM
abousetta Re: Find last data and... 05-24-2012, 10:54 PM
aussieboykie Re: Find last data and... 05-24-2012, 10:55 PM
emina002 Re: Find last data and... 05-25-2012, 12:14 AM
aussieboykie Re: Find last data and... 05-25-2012, 12:20 AM
emina002 Re: Find last data and... 05-25-2012, 12:32 AM
aussieboykie Re: Find last data and... 05-25-2012, 12:56 AM
emina002 Re: Find last data and... 05-25-2012, 01:27 AM
  1. #1
    Forum Contributor
    Join Date
    05-16-2011
    Location
    Philippines
    MS-Off Ver
    Excel 365/Excel 2016
    Posts
    315

    Find last data and perform insert column

    Hi I just want to know how to perform insert column if the macro found the last cell with data in row 2, I got a piece of code already to find the last data in a cell and then after that I don't how to continue this, the logic is to insert new column. Hope you can help me with my code thanks a lot!


    Sub inscol()
    
    Range("B1").End(xlToRight).Select
    ActiveCell.Columns.Insert xlRight
    
    End Sub
    Last edited by emina002; 05-25-2012 at 01:28 AM.

Thread Information

Users Browsing this Thread

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

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