VBA – Determine Start and End Column of a Merged Cell
Written by
Reviewed by
Last updated on March 6, 2022
Here is example code to determine the Start and End Column of a Merged Cell. It assigns the value of each column to a variable and returns them in a message box.
Determine Start and End Columns of Merged Cells
Public Sub StartEndMerge()
'Declare Variables
Dim StartColumn As Integer
Dim EndColumn As Integer
'Assign Variables
StartColumn = ActiveCell.Column
EndColumn = Selection.Columns.Count + StartColumn - 1
'Show Results
MsgBox "Start Column " & StartColumn
MsgBox "End Column " & EndColumn
End SubVBA Coding Made Easy
Stop searching for VBA code online. Learn more about AutoMacro – A VBA Code Builder that allows beginners to code procedures from scratch with minimal coding knowledge and with many time-saving features for all users!
