Actually no, because I want the copied values in a list w/o blanks.
regards
seba
Dne petek, 21. junij 2013 13:15:16 UTC+2 je oseba Vabz napisala:
>
> Superb!!
>
> I assume you need to increment target by 5 too, coz u r copying 5 rows.
>
> Thanks
>
>
> On Fri, Jun 21, 2013 at 4:38 PM, Seba
> > wr
Superb!!
I assume you need to increment target by 5 too, coz u r copying 5 rows.
Thanks
On Fri, Jun 21, 2013 at 4:38 PM, Seba wrote:
> Hi,
>
> thank you for your help.
>
> This is the final version of my code:
>
> Sub copy_transpose_chunks()
>
> Dim count, target, coordS, coordF As Integer
>
Hi,
thank you for your help.
This is the final version of my code:
Sub copy_transpose_chunks()
Dim count, target, coordS, coordF As Integer
coordS = 1
coordF = 5
target = 1
For count = 1 To 15
Range("A" & coordS, "A" & coordF).Select
Selection.Copy
Range("C" &
Hi,
Use this code..
Sub Select_Row()
Range(ActiveCell.Rows, ActiveCell.Offset(4, 0)).EntireRow.Select
End Sub
This will select 5 rows from active cell.
Thanks
On Wed, Jun 19, 2013 at 12:48 PM, Seba wrote:
> Hi,
>
> can someone please advise how to parse a column in excel, so that every 5
>
Hi,
can someone please advise how to parse a column in excel, so that every 5
rows would be a selection, which I can then copy and further manipulate?
Thank you.
Kind regards,
Seba
--
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 offici
