al
> Paste:=xlPasteAll
> Application.CutCopyMode=False
>
> End Sub
>
> Thanks
> Deepak
>
> On Fri, May 6, 2011 at 10:56 AM, NOORAIN ANSARI
> wrote:
>
>
>
>
>
> > -- Forwarded message --
> > From: Bob
> > Date: Fri, May
send email to excel-macros@googlegroups.com
and add the attachment
On Fri, May 6, 2011 at 4:24 PM, Bob wrote:
> Were is it located to attach file? Sorry I don't see it. Thanks
>
> On May 6, 1:25 am, ashish koul wrote:
> > can you share the sample file
> >
> >
> >
> >
> >
> > On Fri, May 6, 20
----
> From: Bob
> Date: Fri, May 6, 2011 at 5:22 AM
> Subject: $$Excel-Macros$$ Copy & Paste next blank row
> To: MS EXCEL AND VBA MACROS
>
>
> I'm sorry , Still having trouble with copy on next available blank
> row. If I record a macro it's:
&g
Were is it located to attach file? Sorry I don't see it. Thanks
On May 6, 1:25 am, ashish koul wrote:
> can you share the sample file
>
>
>
>
>
> On Fri, May 6, 2011 at 5:22 AM, Bob wrote:
> > I'm sorry , Still having trouble with copy on next available blank
> > row. If I record a macro it's:
>
Just add the following line to your code..
Sheets("Customer
Record").Range("ABZ1").End(xlToLeft).Offset(0,1).PasteSpecial
Paste:=xlPasteValues
Regards
Deepak
On Fri, May 6, 2011 at 5:22 AM, Bob wrote:
> I'm sorry , Still having trouble with copy on next available blank
> row. If I record a m
-- Forwarded message --
From: Bob
Date: Fri, May 6, 2011 at 5:22 AM
Subject: $$Excel-Macros$$ Copy & Paste next blank row
To: MS EXCEL AND VBA MACROS
I'm sorry , Still having trouble with copy on next available blank
row. If I record a macro it's:
Columns
can you share the sample file
On Fri, May 6, 2011 at 5:22 AM, Bob wrote:
> I'm sorry , Still having trouble with copy on next available blank
> row. If I record a macro it's:
> Columns("A:E").Select
>Selection.Copy
>Sheets("Customer Record").Select
>ActiveSheet.Paste
> I want to keep
I'm sorry , Still having trouble with copy on next available blank
row. If I record a macro it's:
Columns("A:E").Select
Selection.Copy
Sheets("Customer Record").Select
ActiveSheet.Paste
I want to keep what I have already copied. How do I make it go to the
next available blank row.
Thank
