Re: $$Excel-Macros$$ Re: VBA Error in copying filtered rows

2015-05-18 Thread Mandeep Baluja
, *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

RE: $$Excel-Macros$$ Re: VBA Error in copying filtered rows

2015-05-18 Thread Pankaj Sharma
(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

RE: $$Excel-Macros$$ Re: VBA Error in copying filtered rows

2015-05-18 Thread Nitin Balodi
. 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

RE: $$Excel-Macros$$ Re: VBA Error in copying filtered rows

2015-05-18 Thread Nitin Balodi
@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