,
*Nitin Balodi*
--
Date: Mon, 18 May 2015 04:10:25 -0700
From: rocke...@gmail.com javascript:
To: excel-...@googlegroups.com javascript:
Subject: $$Excel-Macros$$ Re: VBA Error in copying filtered rows
Assign sheet names while defining a range to be copied. means
(xlCellTypeVisible).Copy
Sheets(3).Activate
ActiveSheet.Paste
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On
Behalf Of Nitin Balodi
Sent: Monday, May 18, 2015 6:39 PM
To: excel-macros@googlegroups.com
Subject: RE: $$Excel-Macros$$ Re: VBA Error in copying filtered rows
.
Regards.
Yours Sincerely,Nitin Balodi
Date: Mon, 18 May 2015 04:10:25 -0700
From: rocke...@gmail.com
To: excel-...@googlegroups.com
Subject: $$Excel-Macros$$ Re: VBA Error in copying filtered rows
Assign sheet names while defining a range to be copied. means you should use
Sheet(Name).range(A1
@googlegroups.com
Subject: $$Excel-Macros$$ Re: VBA Error in copying filtered rows
Assign sheet names while defining a range to be copied. means you should use
Sheet(Name).range(A1:A100) instead of Only Range and send me the snapshot
of error.
Regards, Mandeep baluja
On Monday, May 18, 2015 at 4:31