Hi Karan/Norain,
what is use of merging all the cells on a sheet. After merging what are you
going to do with the sheet as it will become like a Notepad page and you
cant use any other formula/function.
I am asking this just out of my curiousity, would appreciate your answer.
Thanks,
Anish
On F
Sub mergeall()
Worksheets("Sheet4").Rows.Select
With Selection
.HorizontalAlignment = xlCenter
.VerticalAlignment = xlBottom
End With
Selection.Merge
End Sub
On Fri, Jul 15, 2011 at 3:03 PM, karan 1237 wrote:
> *
> Hey friend,
>
> I facing this problem. I wan
*
Hey friend,
I facing this problem. I want to merge all columns in one time.
Kαяαη*
On Fri, Jul 15, 2011 at 2:56 PM, NOORAIN ANSARI wrote:
> Dear Karan,
>
> Please try it
>
> Sub mergecell()
> With Selection
> .HorizontalAlignment = xlGeneral
> .MergeCells = True
> End With
> En
PFI
On Fri, Jul 15, 2011 at 2:56 PM, NOORAIN ANSARI wrote:
> Dear Karan,
>
> Please try it
>
> Sub mergecell()
> With Selection
>
.VerticalAlignment = xlBottom
.MergeCells = True
End With
End Sub
On Fri, Jul 15, 2011 at 12:56 PM, karan 1237 wrote:
>
>> Hello Friends,
>>
>> Once a
Dear Karan,
Please try it
Sub mergecell()
With Selection
.HorizontalAlignment = xlGeneral
.MergeCells = True
End With
End Sub
On Fri, Jul 15, 2011 at 12:56 PM, karan 1237 wrote:
> Hello Friends,
>
> Once again I need your help. There is option for merge across in excel but
> is the
