join column & variable

  1. S

    Join Columns into 1 by adding rows and keeping column A data the same

    Merry Christmas! I'm in need of some expert help. Here's a sample of what I'm trying to do in Excel 2007 (using a Macro): Change Part Keyword1 Keyword2 Keyword3 Keyword 4 1122 Cup Ceramic Beverage Mug 1144 Lotion Moisturizer Into Part Keyword1 Keyword2 Keyword3 Keyword 4 1122 Cup 1122...
  2. D

    join column & variable to replace cell number "V65536"

    my question: how do i join "V" (my column) and "erow_three" (my number of rows) to replace "V65536" in the following statement: Range("X1") = "=COUNTA(V2:V65536)" my current code: Dim ws_three As Worksheet Set ws_three = Sheets("Responsiveness - operations")...

Some videos you may like

This Week's Hot Topics

Top