Re: $$Excel-Macros$$ Paste special using skip blank

2013-10-19 Thread Manoj Kumar
** ** > > ** ** > > * * > > *Warm Regards,* > > *Ravi Kumar.* > > ** ** > > *From:* excel-macros@googlegroups.com [mailto: > excel-macros@googlegroups.com] *On Behalf Of *Manoj Kumar > *Sent:* Saturday, October 19, 2013 12:59 PM > *To:* excel-macros@go

RE: $$Excel-Macros$$ Paste special using skip blank

2013-10-19 Thread Manoj Kumar
Hi Expert I m not asking for any macro coding. I just want to know is there any sort cut in excel. Plz help me on this. Thanks Manoj On Oct 19, 2013 10:16 AM, "Ravi Kumar" wrote: > ** ** > > Here is the solution… > > ** ** > > Sub copypastconstants() > > Range("A1:A8").SpecialCells

Re: $$Excel-Macros$$ Paste special using skip blank

2013-10-18 Thread xlstime
as per my understanding its not possible ... we need to create SUB or sort data before paste special or . Enjoy Team XLS On Fri, Oct 18, 2013 at 10:59 PM, Manoj Kumar wrote: > Hi Team > > Can anyone suggest me that. How can I paste data using skip blank. > That all