Written by 
I have used conditional formatting to color cells with numbers (column A): Now i want to reproduce this formatting on a text cell range (column B). I have tried the vba following code but it does now work: Worksheets(“Sheet1”).Range(“B1:B4”).Interior.Color = Worksheets(“Sheet1”).Range(“A1:A4”).Interior.Color Source link
I want to put some data as MergeFields, one per row inside a single cell in a table, without using Select and Selection. I tried many things, even ones sugested by ChatGPT that had some sense in it and they did not work. Note: I will skip variable declarations just to go to the point. […]