PDA

View Full Version : [SOLVED] Query on selection.column



Dreamer
07-03-2005, 10:17 AM
Dear All,

I want to merge the data of column B with the selected column
(I use the cursor to point it), I know the usage .Range(Selection.Column & I)
is not correct... May I know how should I correct it? THX


With activesheet
For I = 2 To .Cells(.Rows.Count, "A").End(xlUp).Row
...........
.Range("B" & I) & " " &.Range(Selection.Column & I) <-----
.............
End If
Next I
End with

Bob Phillips
07-03-2005, 10:40 AM
Is this what you mean


.Range(.Cells(I, "B"), .Cells(I, Selection.Column)).MergeCells = True

Dreamer
07-03-2005, 11:13 AM
Yes..
It's okay now when I use cells... Thanks!