Thank you very much. I enjoy all your tutorials. I have a quick question: is it possible to write 2 codes using bv by val change ? I am unable to do it
Instead of in a fixed range ( A2 :D2) Is it possible to use a dynamic vertical range say A2 : till end of range) for the textjoin formula? I wanted to create an addin button in the ribbon to concatenate the values from the select cell to last row where data is available. Any suggestion?
You can divide the range into row and column to create dynamic range in VBA Code. You can take help from another tutorial. Link is : th-cam.com/video/6edvmcCvCkA/w-d-xo.html
are u able to show a video on textjoin + if function vba referencing to another workbook?
Thank you very much. I enjoy all your tutorials. I have a quick question: is it possible to write 2 codes using bv by val change ? I am unable to do it
Yes, you can do that.
@@ExcelDestination it says It.cannot ?
I mean I tried but it is not letting me
amazing!!
Thank You So Mutch, Sir.
Nice explanation
Thank You!
Hi sir , i wanted your help in making this code , using filter and puting condition for it
Instead of in a fixed range ( A2 :D2) Is it possible to use a dynamic vertical range say A2 : till end of range) for the textjoin formula? I wanted to create an addin button in the ribbon to concatenate the values from the select cell to last row where data is available. Any suggestion?
You can divide the range into row and column to create dynamic range in VBA Code. You can take help from another tutorial. Link is :
th-cam.com/video/6edvmcCvCkA/w-d-xo.html
Hi how creat vba code to run macro when open powerpoint
you can use VBA Code in Power Point event instead of using vba code in excel.
How to use Textjoin for rows with if condition
can you please elaborate with example.......I will try to help you.
Sir make filter formula
ok