You're welcome, i'am glad you've got it.
Pada 25/07/2013 14:21, Prafull Jadhav menulis:
Dear Sir,
Thanks a lot and lot ...for explain the below code in smooth manner.
I have started practice on Macro from last 3 Month.
Dim i As Range
For Each i In Range("A2:A" & Sheet1.UsedRange
Dear Sir,
Thanks a lot and lot ...for explain the below code in smooth manner.
I have started practice on Macro from last 3 Month.
Dim i As Range
> For Each i In Range("A2:A" & Sheet1.UsedRange.Rows.Count)
> i.Offset(, 2) = i & "|" & i.Offset(, 1)
> Next
> End Sub
>
This new
*Offset ([row], [column])*
lets say i => Range B3 => same as i.offset(0,0)
thenif we want to select Range C4 that should be i.offset(1,1) => 1 Row
and 1 column from B3
If we want to select A1 ==> i.offset(-2,-1) => 2 Row before and 1 column
before B3
*i.Offset(, 2) = i & "|" & i.Offset(, 1
