Results 1 to 5 of 5

Dim Lastrow ? Dim LastColumn

Threaded View

  1. #1
    Forum Contributor
    Join Date
    12-16-2006
    Posts
    349

    Dim Lastrow ? Dim LastColumn

    I am very fimilar with Dim Lastrow,

    Dim lastrow As Long
        lastrow = Cells(Rows.Count, "B").End(xlUp).Row
    but how can I

    dim lastcolumn ? so it would look for through row 3 from A TO IV and find which column had the last value in and the when I fill right I only want it to fill to that last column.

    Any help ?
    Last edited by VBA Noob; 01-10-2008 at 09:35 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