Pfa,,
Type:=8 refer to range
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Prabhu Pinky
Sent: Sunday, March 16, 2014 12:21 PM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ query2
hi experts,
PFA, i have few names in sheet 1, my re
thanks asish,
but in second sheet, names should start from 3rd row only. i mean from B3
onwards only.
Thanks & Regards,
Prabhu R
On 16 March 2014 12:50, ashish koul wrote:
>
> Sub test()
> Dim cl As Range
> Dim j As Long
> For Each cl In Sheets("Sheet1").Range("b3:b7")
> j = Sheets("Sheet2")
Sub test()
Dim cl As Range
Dim j As Long
For Each cl In Sheets("Sheet1").Range("b3:b7")
j = Sheets("Sheet2").Range("C65356").End(xlUp).Row
Sheets("Sheet2").Range("C" & j & ":c" & j + 3).Value = cl.Value
Next
End Sub
On Sun, Mar 16, 2014 at 12:21 PM, Prabhu Pinky wrote:
> hi experts,
>
> PFA
