Results 1 to 2 of 2

Thread: Copy text in a column till last row based on adjacent column

  1. #1

    Copy text in a column till last row based on adjacent column



    Register for a FREE account, and/
    or Log in to avoid these ads!

    Code:
    Workbooks.Add 
    newWB = ActiveWorkbook.Name 
     
    Set lastrow = Range(Workbooks(newWB).Sheets("Sheet1").range("g") & Rows.Count).End(xlUp).Row 
    Range("f2:f" & lastrow) = "CB"

  2. #2
    hi could you please help me out with this code getting error while running, many thanks

    Code:
    Workbooks.Add 
    newWB = ActiveWorkbook.Name 
     
    Set lastrow = Range(Workbooks(newWB).Sheets("Sheet1").range("g") & Rows.Count).End(xlUp).Row 
    Range("f2:f" & lastrow) = "CB"

Posting Permissions

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