• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

merge cells in VBA

M

madhavi

New Member
Hi ,


I have to find a text in the sheet and from that cell i have to merge 6 cells horizontally . I am not good at VBA . i need help please

i have written a code for finding the text

Set cell = ActiveSheet.Cells.Find(What:="~ ~ Enquiries", After:=[A1], LookIn:=xlFormulas, LookAt:=xlPart, SearchOrder:=xlByRows, SearchDirection:=xlNext, MatchCase:=False, SearchFormat:=False)

and it is working . after that ther is no clue for me
 
You must log in or register to reply here.
Back
Top