Hi,
I need to merge certain columns like A2:G2 and merging should continue until A15:G15. Currently I have written a syntax Range(A2:G2).Merge which works perfect. to make it with the "I" loop for example
for I=0 to 14
Range(A2+i:G2+i).Merge
I=I+1
Next I
it doesn't work and gives me an error. I tried different syntax range(""A""& 2+i:""G""&2+i).Merge and this also gives me error. Could anyone help me to fix this.
Thanks,
Bookmarks