Can you attached excel file pleaes??
-----Original Message-----
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of LearnExcel
Sent: Mar/Tue/2012 07:16
To: MS EXCEL AND VBA MACROS
Subject: Re: $$Excel-Macros$$ copy range
for some reason it wont work but you should be able to paste this data
data name nam nam nam nam nam nam nam
3/5/2012 random john bob dog bob john new
name nam
3/6/2012 random john bob dog bob john new
name nam
3/6/2012 random john bob dog bob john new
name nam
3/6/2012 bob dog bob john random random
john bob
3/6/2012 john bob dog bob john random
john bob
3/6/2012 random john bob dog bob john new
name nam
3/6/2012 bob bob dog bob john random
john bob
3/6/2012 random john bob bob random random
john bob
3/6/2012 random john bob dog bob john new
name nam
Name report
On Mar 6, 8:30 am, Sam Mathai Chacko <samde...@gmail.com> wrote:
> Will be easier if you attach a sample file
>
> Sam
>
>
>
>
>
>
>
>
>
> On Tue, Mar 6, 2012 at 5:51 AM, LearnExcel <sendse...@gmail.com> wrote:
> > Hi Guys/Girls i use VBA to copy a range using the following code
>
> > Selection.AutoFilter Field:=7, Criteria1:="bob"
> > ActiveSheet.Range("a1:o1",
> > ActiveSheet.Range("a1").End(xlDown)).Select
>
> > the problem that i have is in cell "G" after the last cell there is
> > a
> > 3 lines of blank cell and then the report,
>
> > once the filter is made i want the cell to also include the"Name
> > report"
>
> > can anyone help?
>
> > data name nam nam nam nam nam nam nam
> > 3/5/2012 random john bob dog bob john new
> > name
> > nam
> > 3/6/2012 random john bob dog bob john new
> > name
> > nam
> > 3/6/2012 random john bob dog bob john new
> > name
> > nam
> > 3/6/2012 bob dog bob john random random john
> > bob
> > 3/6/2012 john bob dog bob john random john
> > bob
> > 3/6/2012 random john bob dog bob john new
> > name
> > nam
> > 3/6/2012 bob bob dog bob john random john
> > bob
> > 3/6/2012 random john bob bob random random john
> > bob
> > 3/6/2012 random john bob dog bob john new
> > name
> > nam
>
> > Name report
>
> > --
> > FORUM RULES (986+ members already BANNED for violation)
>
> > 1) Use concise, accurate thread titles. Poor thread titles, like
> > Please Help, Urgent, Need Help, Formula Problem, Code Problem, and
> > Need Advice will not get quick attention or may not be answered.
>
> > 2) Don't post a question in the thread of another member.
>
> > 3) Don't post questions regarding breaking or bypassing any security
> > measure.
>
> > 4) Acknowledge the responses you receive, good or bad.
>
> > 5) Cross-promotion of, or links to, forums competitive to this
> > forum in signatures are prohibited.
>
> > NOTE : Don't ever post personal or confidential data in a workbook.
> > Forum owners and members are not responsible for any loss.
>
> > --------------------------------------------------------------------
> > ------- --------------------------- To post to this group, send
> > email to excel-macros@googlegroups.com
>
> --
> Sam Mathai Chacko
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please
Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will
not get quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security
measure.
4) Acknowledge the responses you receive, good or bad.
5) Cross-promotion of, or links to, forums competitive to this forum in
signatures are prohibited.
NOTE : Don't ever post personal or confidential data in a workbook. Forum
owners and members are not responsible for any loss.
----------------------------------------------------------------------------
--------------------------
To post to this group, send email to excel-macros@googlegroups.com
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Cross-promotion of, or links to, forums competitive to this forum in
signatures are prohibited.
NOTE : Don't ever post personal or confidential data in a workbook. Forum
owners and members are not responsible for any loss.
------------------------------------------------------------------------------------------------------
To post to this group, send email to excel-macros@googlegroups.com
