Atul,
Please use below coding it will help you to delete the blank cell of column A.
Sub Macro6()
Columns("A:A").Select
Selection.SpecialCells(xlCellTypeBlanks).Select
Selection.Delete Shift:=xlUp
End Sub
Regards,
Shrinivas
Citi(r) Global Transaction Services - India
UB City, Canberra Block, # 24, Vittal Mallya Road,
Bangalore - 56 00 01.
Ph - +91-80-4144 6339 / 6340
Email - [email protected]
-----Original Message-----
From: [email protected] [mailto:[email protected]] On
Behalf Of Dilip Pandey
Sent: Wednesday, June 29, 2011 12:16 PM
To: [email protected]
Cc: [email protected]
Subject: Re: $$Excel-Macros$$ Macro to copy and paste selected raws.xls
Hi Atul,
You were clear in the first email itself. It is my mistake that I had
overlooked the point.
Now I have revised the macro and it should work fine.
Feel free to get back in case of any queries. Thanks.
Regards,
DILIPandey
On 6/29/11, Atul <[email protected]> wrote:
> Hi Dilipji,
>
> Thank you for your response.
>
> It seems that macro is hidiing weekends and holidays upon copying raws
> to the new file.
>
> Actually, I need macro to copy over only the first business day of
> each month for atleast next months. For that reason I highlighted
> selected raws in yellow. The ultimate result should contain only one
> raw for each month being the first business day of respective month.
>
> Please modify macro appropriately. I hope I could make it clear this
> time.
>
> Apology if it was not clear on earler email.
>
> Atul
>
> On Jun 27, 2:51 am, Dilip Pandey <[email protected]> wrote:
>> Hi Atul,
>>
>> Please find a quick solution attached herewith :) Feel free to get
>> back in case of any queries.
>>
>> Regards,
>> DILIPandey
>>
>> On 6/27/11, Atul Patel <[email protected]> wrote:
>>
>>
>>
>>
>>
>> > Attachment to my request.
>>
>> > Attached is a sample file. I need a macro code to copy selected
>> > raws (yellow highlighted) from the liquidity tab of a given
>> > spreadsheet and paste to other file say 'Book1'. The selection
>> > criteria would be based on Column A. I want to copy first working
>> > day of each month. the day should not be either saturday, sunday or
>> > holidays. (you can have list of holidays on other tab approx 10
>> > days in a given calendar year)
>>
>> > Per my understanidng this task can be done other way also, copy
>> > entire spread sheet to Book1 and delete unwanted raws ( means raws
>> > not matching above criteria)
>>
>> > Much wiill be appreciated if some one help me this.
>>
>> > Thanks,
>>
>> > Atul
>>
>> > Atul Patel
>> > 905 785 8324(H)
>> > 647 898 4074(C)
>> > [email protected]
>> > [email protected]
>>
>> > Good to know you !
>>
>> > --
>> >
>> >--------------------------------------------------------------------
>> >-------------- Some important links for excel users:
>> > 1. Follow us on TWITTER for tips tricks and links :
>> >http://twitter.com/exceldailytip
>> > 2. Join our LinkedIN group
>> >@http://www.linkedin.com/groups?gid=1871310
>> > 3. Excel tutorials athttp://www.excel-macros.blogspot.com
>> > 4. Learn VBA Macros athttp://www.quickvba.blogspot.com
>> > 5. Excel Tips and Tricks athttp://exceldailytip.blogspot.com
>>
>> > To post to this group, send email to [email protected]
>>
>> > <><><><><><><><><><><><><><><><><><><><><><>
>> > Like our page on facebook , Just follow below link
>> >http://www.facebook.com/discussexcel
>>
>> --
>> Thanks & Regards,
>>
>> DILIP KUMAR PANDEY, mvp
>> MBA,B.Com(Hons),BCA
>> Mobile: +91 9810929744
>> [email protected]
>> [email protected]
>> New Delhi - 62, India
>>
>> Macro to copy and paste selected raws.xls
>> 55KViewDownload- Hide quoted text -
>>
>> - Show quoted text -
>
> --
> ----------------------------------------------------------------------
> ------------
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @
> http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips
> and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to [email protected]
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>
--
Thanks & Regards,
DILIP KUMAR PANDEY, mvp
MBA,B.Com(Hons),BCA
Mobile: +91 9810929744
[email protected]
[email protected]
New Delhi - 62, India
--
----------------------------------------------------------------------------------
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip 2. Join our LinkedIN group @
http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and
Tricks at http://exceldailytip.blogspot.com
To post to this group, send email to [email protected]
<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel
--
----------------------------------------------------------------------------------
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
To post to this group, send email to [email protected]
<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel
