Re: $$Excel-Macros$$ Re: Delete Blank Cells.xlsx

2012-06-27 Thread Prince Dubey
Hi Lalit, there is no difference between both the solution, It is due to by mistake. regards Prince dubey. On Wednesday, 27 June 2012 19:14:08 UTC+5:30, Lalit_Mohan wrote: > Hi Prince, > > Sorry for asking but could you please explain the deference in both of > your solution. > > Regar

RE: $$Excel-Macros$$ Re: Delete Blank Cells.xlsx

2012-06-27 Thread Viswanathan Yoganathan
Hi, Do we have any vba code, The number of cells we are deleting in between data and the same number of cell to be inserted at the end of data. I believe by doing this the range would not change for the next month. Thanks, Vishwa From: excel-macros@googlegroups.com [mailto:excel-macros@googleg

Re: $$Excel-Macros$$ Re: Delete Blank Cells.xlsx

2012-06-27 Thread ╰» ℓαℓιт мσαнη
Hi Prince, Sorry for asking but could you please explain the deference in both of your solution. Regards, Lalit Mohan On Wed, Jun 27, 2012 at 8:32 AM, Prince Dubey wrote: > Hi Vishwa, > > > Try This > > > > Public Sub DeleteWeekends() >     Dim rng As Range >     Dim rngData As Ran

RE: $$Excel-Macros$$ Re: Delete Blank Cells.xlsx

2012-06-26 Thread Viswanathan Yoganathan
Hi, I need the date should be like how I arranged in the column B. Thanks, Vishwa From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Vish Sent: Wednesday, June 27, 2012 1:19 AM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Re: Delete

Re: $$Excel-Macros$$ Re: Delete Blank Cells.xlsx

2012-06-26 Thread Vish
Hi Vishwa, Hope this helps. Please let me know. Thanks, Vish -- -- 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 atte

RE: $$Excel-Macros$$ Re: Delete Blank Cells.xlsx

2012-06-26 Thread Viswanathan Yoganathan
Saturday and Sunday From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Vish Sent: Wednesday, June 27, 2012 1:00 AM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Re: Delete Blank Cells.xlsx Hi Vishwa, By Weekends you mean Saturday and Sunday or