siddhuprince86
New Member
Hello Guys,
I am new to VBA programming , I have recently created a User form , wrote down the code to transfer to the Excel format ,
In this course of action, some Columns like material are having values for 4 individual Rows , rest of the columns only 4 Row is having the values ,
I wanted to merge the before cells to make the sheet legible,
I have used
I am enable made it in code format it is not working
I am new to VBA programming , I have recently created a User form , wrote down the code to transfer to the Excel format ,
In this course of action, some Columns like material are having values for 4 individual Rows , rest of the columns only 4 Row is having the values ,
I wanted to merge the before cells to make the sheet legible,
I have used
Code:
Sub vba_merge()
Dim sh As Worksheet
Set sh = ThisWorkbook.Sheets("Supplier master")
With sh.Range("B" & n + 4)
.Merge
.HorizontalAlignment = xlCenter
.VerticalAlignment = xlCenter
End With
End Sub
I am enable made it in code format it is not working
Attachments
Last edited by a moderator: