Variable Cell Merge

[VaYooper]

Hello.... I'm trying to figure how to merge two variable cells. Below is part of my code. What I'm trying to do is merge the cell in Column C and the cell in Column D. Appreciate any assistance provided. Thanks

 LastRow = Cells(Rows.Count, "A").End(xlUp).Row + 2
   ActiveSheet.Cells(LastRow, "B").Value = "Inv Correct"
   ActiveSheet.Cells(LastRow, "C").HorizontalAlignment = xlCenter
   ActiveSheet.Cells(LastRow, "D").HorizontalAlignment = xlCenter

 

[Fluff]

I'm trying to figure how to merge two variable cells.

Don't

Merged cells are a massive problem, try this instead

ActiveSheet.Cells(Lastrow, "C").Resize(, 2).HorizontalAlignment = xlCenterAcrossSelection

 

[VaYooper]

Ok... I will heed your advice. Thanks

 

[Fluff]

You're welcome