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")...

This Week's Hot Topics

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top