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
hi experts,
PFA, i have few names in sheet 1, my requirements in sheet 2.
please help me with macro coding.
Thanks Regards,
Prabhu R
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It's
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
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 prabhupin...@gmail.comwrote:
hi experts,
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 koul.ash...@gmail.com wrote:
Sub test()
Dim cl As Range
Dim j As Long
For Each cl In Sheets(Sheet1).Range(b3:b7)
j =