macro to copy into different worksheets
- From: sarahphonics <sarahphonics@xxxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Thu, 30 Jun 2005 04:03:02 -0700
I have a excel work*** which shows a list like below.
Directory of C:\Sarah\files\Dec04
09/02/2005 13:30 6,312 Dec04.sav
1 File(s) 6,312 bytes
Directory of C:\Sarah\code\Admissions\0001
20/04/2004 14:45 290,929,896 adm0001.sav
1 File(s) 290,929,896 bytes
What I want a macro to do is to look down this work*** and select each
record on the list. I.E find the line starting with the word Directory,
selecting all the lines below until it gets to another line starting with
Directory, it then pastes this into a different work***. then goes back and
selects the next record etc. The distance between the rows containing
"Directory" can vary in length.
I am not very experienced in Visual Basic and I can not get it to select the
range of rows I need.
.
- Follow-Ups:
- Re: macro to copy into different worksheets
- From: Dave Peterson
- Re: macro to copy into different worksheets
- Prev by Date: Re: Database-Query and AutoFill??????
- Next by Date: Re: Password Protecting
- Previous by thread: Etiquette for hyperlinks
- Next by thread: Re: macro to copy into different worksheets
- Index(es):