Merge macro with unknown value

[jose001]

Hi All,

Could anyone take a look at this snippet of code and wokout what I'm doing wrong. Its copying the value of A2 down as far as the last filled cell in column four just fine but I can't get it to merge cells i.e from b2: b...what ever is the value for D. I have tried using selection but that doesn't work either

'Formating
LimitD = Cells(Rows.Count, 4).End(xlUp).Row
Range("B2:B" & LimitD).MergeCells = True
Range("C2:C" & LimitD).MergeCells = True
Range("A2:A" & LimitD).Value = Range("A2").Value

Jose

 

[ravishankar]

Hi
I have used your code (without any change) and it merges col B and C till the last row of D (& fills col A too).
Ravi