Hi Riste Chaushev, As I don't know how you modified the file, it is difficult to answer with certainty. Can you share part of your file as modified an...
Paul, A new version. BR, Lionel
Hi Paul, Here is a solution with a formula. BR, Lionel
Hi, Marsil, I just left on another version to avoid the previous problems. It should work. BR, Lionel
Marsil, This ? I hope. NB :
Marsil, Here is an adaptation. BR, Lionel
Hi kunal upreti, You can perform this operation with MATCH - INDEX and a joker. BR, Lionel
David, On my pc, all the spaces are deleted. Can you provide a file with the problem? BR, Lionel
Hi Marsil Here is a solution found on the net. BR, Lionel
Hi John, When I try this code on my machine, everything seems correct (png). Could you put an example of your file or a photo that is problematic. ...
Hi David, Here is a code that does what you ask. : Sub Space() Dim Ligne As Integer, cell As Range With Sheets("Sheet2") 'Determines the last ...
Hi John, From what I understand, you should use the EOMONTH formula. Here is the description: eomonth-function. Now, to be more precise in the answer,...
Re-Hi, I haven't understood everything yet, but I think I'm getting closer to the truth: in Sheet2, you do your encoding. Then, this encoding is re...
Hi, You ask the question with 20 shapes. OK. But there are not enough elements to answer you. What do you want to do with these 20 shapes? Will it ...
Re-Hi Riste Chaushev, To use the RGB code, do the following: Sheets("Sheet1").Shapes("Rectangle: Rounded Corners 1").Fill.ForeColor.RGB = RGB(25...