vba concatenate

  1. R

    VBA Concatenate Issue

    I'm not understanding why the code below will generate a #REF! error on the last cell identified to be concatenated (Row 3: Minnie Mouse), yet when I go into where the formula is copied, and I physically replace it with the cell I reference, it gets me exactly what I want (Row 2: Mickey Mouse)...
  2. E

    Using Export to PDF Issue

    I am at a loss for how to fix this issue I am having. I am sure it is something simple, but I think I have stared at it too long to understand what mistake I am making. As the name indicates, I am new to VBA and learning in order to make my life and my coworkers lives easier. Context: We have a...
  3. S

    How to Concat or VBA Based on a cell value

    hi all, i have 800,00 rows of data and i need to move the text into 1 cell where they have a matching value in another cell. <tbody> 11723 scott smith scott smith 11723 jack harry scott smith, jack harry 11723 ben phillips scott smith, jack harry, ben phillips 11122 carrie cloud carrie...
  4. M

    Need a macro that populates statement based on the header

    Dear Team, Need a macro which will create a statement based on the header information dynamically and iterate till the last row in the data in excel. Header information wont be static all the time. It changes all the time :) <tbody> emp ename dept 10 kiran 50 20 shiva 30 </tbody> Need...
  5. T

    Loop through array - looking up multiple columns

    <TBODY> Data_Tbl</SPAN></SPAN> Staff_ID</SPAN></SPAN> Department 1</SPAN></SPAN> Department 2</SPAN></SPAN> Department 3</SPAN></SPAN> City</SPAN></SPAN> Date Hired</SPAN></SPAN> Grade</SPAN></SPAN> Hotspot Level</SPAN></SPAN> ID1</SPAN> Marketing</SPAN> Analytics</SPAN> Core...

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
Back
Top