merge cell vba

Hi all, I am trying to merge cells using macro, but it works quite oddly and I cannot pick the mistake in code. Code: Sub testee() Application.DisplayAlerts = False Dim rng As Range MergeCells: For Each rng In Selection If rng.Value = rng.Offset(1, 0).Value...

Hello folks, I am desperate to scan the tables via Vba and determine specific values. I have a master table (first table) that is automatically generated in a sheet every day. This table should be compared with the table on the left (here as an example below) and the data from the master...

Hello, I have a workbook that contains classes a person must take based on their roles in a system (job duties). Because each roles requires certain classes and all of the roles have repeated classes, I would like to combine the rows based on the user while keeping all unique values and keeping...

Hi, hoping someone can help as I cannot find a solution at all. I have a workbook with two sheets. One is the active data sheet (sheet 1), the other is a reference / list (sheet 2). Sheet 2 details across the columns (C:E) the 'Types', and below each type, lists the Tasks for that type (used...

can anyone help me on following problem, i highlighted rows with conditional formatting, any row with date on sunday is highlighted, i want excel to merge cells C,D & E on sunday,plus show "Sunday" in highlighted cells as well. Please help.