+ Reply to Thread
Results 1 to 2 of 2

how to used till last used row instead 1 to 50

  1. #1
    Forum Contributor
    Join Date
    04-25-2014
    Location
    India
    MS-Off Ver
    Excel pro plus 2021
    Posts
    186

    how to used till last used row instead 1 to 50

    Sub Concatenate_Example3()
    Dim i As Integer
    For i = 1 To 50
    Cells(i, 16).Value = Cells(i, 10) & "-" & Cells(i, 11) & "-" & Cells(i, 12)
    Cells(i, 17).Value = "??????" & Cells(i, 1)
    Next i
    End Sub

    hello everyone,

    how to used till last used row instead 1 to 50
    sometimes last used row is 15
    sometimes last used row is 55

  2. #2
    Valued Forum Contributor
    Join Date
    06-27-2010
    Location
    sYRIA
    MS-Off Ver
    Excel 2013
    Posts
    669

    Re: how to used till last used row instead 1 to 50

    Hi
    Try tis way
    Please Login or Register  to view this content.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Summing Data With Criteria Q1, till Q2, till Q3 etc...
    By Jhon Mustofa in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 12-10-2021, 03:03 AM
  2. Replies: 2
    Last Post: 02-02-2017, 05:18 AM
  3. Sum till the column till the date match
    By ursanil in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 03-02-2014, 06:29 AM
  4. [SOLVED] sort till last row
    By pedjvak in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 11-14-2012, 05:27 AM
  5. using data till till the current row
    By nilu8603 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-26-2010, 04:30 AM
  6. SUM C IF B=Cap... Till Next B=Cap...
    By cradino in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 10-12-2005, 08:05 PM
  7. [SOLVED] SUM C IF B=Cap...TILL NEXT B=Cap...
    By cradino in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 10-09-2005, 09:05 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