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
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
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 @
https://www.fa
