How to identify the first and last cells of a range of cells with the same value & merge?

[Eduards]

I am currently developing an application using C# involving Excel. It's difficult to create logic within C# to get a desired Excel output.

So I have an idea to insert VBA code into Excel via C#.

I am no expert in VBA - I am needing help to achieve the following output:

Situation

I am aiming to merge the values like so:

1.jpg

Desired output

And here is my desired output:

2.jpg

Using VBA, how can I achieve such target.

My attempt

Please Login or Register  to view this content.

I gave it an attempt from some research.. this is working.. but I couldn't find anything to merge to the A4 page break.

[KOKOSEK]

You are interesting in which row PageBreaks are.
use:

Please Login or Register  to view this content.

to find out row for X pagebreak.
Then in loop

Please Login or Register  to view this content.

do merge.

[Bo_Ry]

Please try

Please Login or Register  to view this content.

[Eduards]

Thank you for that.. How would I change this to E & D columns I changed it to this.. but nothing is happening.

Please Login or Register  to view this content.

[Bo_Ry]

Maybe try

Please Login or Register  to view this content.

If this doesn't work, please provide sample file.

[Eduards]

Hi,

Shows a subscript out of range error.

But - If I clear out the values in the A column.. it works as expected...

[Bo_Ry]

Try

Please Login or Register  to view this content.

[Eduards]

See the print preview for the attached workbook.

Untitled.jpg

[Bo_Ry]

Something weird with Footer.

try this

Please Login or Register  to view this content.

[Eduards]

That is perfect, just what I was after. Appreciate your help.

[Eduards]

Sorry to bother.. getting a subscript out of range for this one.

[Bo_Ry]

Last try

Please Login or Register  to view this content.