$$Excel-Macros$$ Re: Creating empty rows b/w filed rows without ASAP
Thanx dilip, my problem is solved. A learn a lot form u. rgds, Mahesh On Fri, Jul 17, 2009 at 8:42 AM, Mahesh mahender.bi...@gmail.com wrote: Hi Dili, Gud Morning, I using the same file which is already attached. On Thu, Jul 16, 2009 at 5:42 PM, Dilip Pandey dilipan...@gmail.comwrote: Dear Mahesh, It will be good to explain, if you can share the test worksheet with us (having relevant data portion). Thanks DILipandey (Back from Holidays) -- DILIP KUMAR PANDEY MBA-HR,B COM(Hons.),BCA Mobile: +91 9810929744 dilipan...@gmail.com dilipan...@yahoo.com New Delhi - 110062 On Thu, Jul 16, 2009 at 5:15 PM, Mahesh mahender.bi...@gmail.comwrote: hi Dilip, I am using Excel 2007. On Thu, Jul 16, 2009 at 5:10 PM, Mahesh mahender.bi...@gmail.comwrote: Hi Dilip, But when i pressed up arrow the selection automatical removed for the sheet. Rgds, Mahender Bisht On Thu, Jul 16, 2009 at 4:26 PM, Dilip Pandey dilipan...@gmail.comwrote: Hi Mahesh, now do UpArrow - means press up arrow key of your keyboard and press CTRL + Enter. For your convienience, entire process is explained below:- Select the data, leaving headings Press F5 Press Alt + s Press k Press Enter Press Up Arrow Press Ctrl + Enter Thanks Best Regards, DILipandey (Back from Holidays) -- DILIP KUMAR PANDEY MBA-HR,B COM(Hons.),BCA Mobile: +91 9810929744 dilipan...@gmail.com dilipan...@yahoo.com New Delhi - 110062 Press F5 - Alt + S - k - hit enter. Now do UpArrow and press Ctrl + Enter). On Thu, Jul 16, 2009 at 3:17 PM, Mahesh mahender.bi...@gmail.comwrote: Hi Dilip, What do u mean by now do UpArrow , unable to understand. Rgds, Mahender Bisht On Thu, Jul 16, 2009 at 3:04 PM, Dilip Pandey dilipan...@gmail.com wrote: *Dear Mahesh,* According to me, the best way is to follow the below method:- Select the blank region (cells), right below the data headings. (Press F5 - Alt + S - k - hit enter. Now do UpArrow and press Ctrl + Enter). It will fill out the blank cells with the data from above row. If you want you can share the spreadsheet with the group as well, so that we can do it and then you can check the results. Thanks, DILipandey (Back from Holidays) -- DILIP KUMAR PANDEY MBA-HR,B COM(Hons.),BCA Mobile: +91 9810929744 dilipan...@gmail.com dilipan...@yahoo.com New Delhi - 110062 On Thu, Jul 16, 2009 at 1:08 PM, Mahesh mahender.bi...@gmail.comwrote: Hi, Now i also want to copy data from the above row , kindly provide the code And syntax. Thanx in advanc On Thu, Jul 16, 2009 at 12:48 PM, Mahesh mahender.bi...@gmail.com wrote: Thanx bor On Thu, Jul 16, 2009 at 12:47 PM, Dilip Pandey dilipan...@gmail.com wrote: Hi Maehsh, Your requirement is attached herewith. Thanks, DILipandey (Back from Holidays) -- DILIP KUMAR PANDEY MBA-HR,B COM(Hons.),BCA Mobile: +91 9810929744 dilipan...@gmail.com dilipan...@yahoo.com New Delhi - 110062 On Thu, Jul 16, 2009 at 8:53 AM, Mahesh mahender.bi...@gmail.com wrote: Hi Dilip, thanx for your prompt reply but it not working. Can you send my the xls sheet. Rgds, Mahesh On Wed, Jul 15, 2009 at 7:30 PM, Dilip Pandey dilipan...@gmail.com wrote: Hi Mahesh, Open the code and repeat the following line twice (i.e. one more time) as it is already there in the code:- Selection.EntireRow.insert Thanks DILipandey (Back from Holidays) -- DILIP KUMAR PANDEY MBA-HR,B COM(Hons.),BCA Mobile: +91 9810929744 dilipan...@gmail.com dilipan...@yahoo.com New Delhi - 110062 On Wed, Jul 15, 2009 at 5:49 AM, Mahesh mahender.bi...@gmail.com wrote: Thanx, What chage should i do to insert two rows at ones. Thanx again On Wed, Jul 15, 2009 at 4:27 PM, Dilip Pandey dilipan...@gmail.com wrote: Hi Mahesh, Please find the attached file with Macro. Thanks Dilipandey (Back from Holidays) -- DILIP KUMAR PANDEY MBA-HR,B COM(Hons.),BCA Mobile: +91 9810929744 dilipan...@gmail.com dilipan...@yahoo.com New Delhi - 110062 On Wed, Jul 15, 2009 at 9:04 AM, Mahesh mahender.bi...@gmail.com wrote: Hi folks, Gud Morning I want insert empty row between the rows containing data with the hepl of macro. Please also suggested how to use it in Excel 2007. Thanks in advance... -- With Love, Mahesh Bisht -- With Love, Mahesh Bisht -- With Love, Mahesh Bisht -- With Love, Mahesh Bisht -- With Love, Mahesh Bisht -- With Love, Mahesh Bisht -- With Love, Mahesh Bisht -- With Love, Mahesh Bisht -- With Love, Mahesh Bisht -- With Love, Mahesh Bisht --~--~-~--~~~---~--~~ -- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel
$$Excel-Macros$$ Re: Creating empty rows b/w filed rows without ASAP
Hi, Now i also want to copy data from the above row , kindly provide the code And syntax. Thanx in advanc On Thu, Jul 16, 2009 at 12:48 PM, Mahesh mahender.bi...@gmail.com wrote: Thanx bor On Thu, Jul 16, 2009 at 12:47 PM, Dilip Pandey dilipan...@gmail.comwrote: Hi Maehsh, Your requirement is attached herewith. Thanks, DILipandey (Back from Holidays) -- DILIP KUMAR PANDEY MBA-HR,B COM(Hons.),BCA Mobile: +91 9810929744 dilipan...@gmail.com dilipan...@yahoo.com New Delhi - 110062 On Thu, Jul 16, 2009 at 8:53 AM, Mahesh mahender.bi...@gmail.com wrote: Hi Dilip, thanx for your prompt reply but it not working. Can you send my the xls sheet. Rgds, Mahesh On Wed, Jul 15, 2009 at 7:30 PM, Dilip Pandey dilipan...@gmail.comwrote: Hi Mahesh, Open the code and repeat the following line twice (i.e. one more time) as it is already there in the code:- Selection.EntireRow.insert Thanks DILipandey (Back from Holidays) -- DILIP KUMAR PANDEY MBA-HR,B COM(Hons.),BCA Mobile: +91 9810929744 dilipan...@gmail.com dilipan...@yahoo.com New Delhi - 110062 On Wed, Jul 15, 2009 at 5:49 AM, Mahesh mahender.bi...@gmail.comwrote: Thanx, What chage should i do to insert two rows at ones. Thanx again On Wed, Jul 15, 2009 at 4:27 PM, Dilip Pandey dilipan...@gmail.comwrote: Hi Mahesh, Please find the attached file with Macro. Thanks Dilipandey (Back from Holidays) -- DILIP KUMAR PANDEY MBA-HR,B COM(Hons.),BCA Mobile: +91 9810929744 dilipan...@gmail.com dilipan...@yahoo.com New Delhi - 110062 On Wed, Jul 15, 2009 at 9:04 AM, Mahesh mahender.bi...@gmail.comwrote: Hi folks, Gud Morning I want insert empty row between the rows containing data with the hepl of macro. Please also suggested how to use it in Excel 2007. Thanks in advance... -- With Love, Mahesh Bisht -- With Love, Mahesh Bisht -- With Love, Mahesh Bisht -- With Love, Mahesh Bisht -- With Love, Mahesh Bisht --~--~-~--~~~---~--~~ -- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com HELP US GROW !! We reach over 5,000 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -~--~~~~--~~--~--~---
$$Excel-Macros$$ Re: Creating empty rows b/w filed rows without ASAP
Hi Dilip, What do u mean by now do UpArrow , unable to understand. Rgds, Mahender Bisht On Thu, Jul 16, 2009 at 3:04 PM, Dilip Pandey dilipan...@gmail.com wrote: *Dear Mahesh,* According to me, the best way is to follow the below method:- Select the blank region (cells), right below the data headings. (Press F5 - Alt + S - k - hit enter. Now do UpArrow and press Ctrl + Enter). It will fill out the blank cells with the data from above row. If you want you can share the spreadsheet with the group as well, so that we can do it and then you can check the results. Thanks, DILipandey (Back from Holidays) -- DILIP KUMAR PANDEY MBA-HR,B COM(Hons.),BCA Mobile: +91 9810929744 dilipan...@gmail.com dilipan...@yahoo.com New Delhi - 110062 On Thu, Jul 16, 2009 at 1:08 PM, Mahesh mahender.bi...@gmail.comwrote: Hi, Now i also want to copy data from the above row , kindly provide the code And syntax. Thanx in advanc On Thu, Jul 16, 2009 at 12:48 PM, Mahesh mahender.bi...@gmail.comwrote: Thanx bor On Thu, Jul 16, 2009 at 12:47 PM, Dilip Pandey dilipan...@gmail.comwrote: Hi Maehsh, Your requirement is attached herewith. Thanks, DILipandey (Back from Holidays) -- DILIP KUMAR PANDEY MBA-HR,B COM(Hons.),BCA Mobile: +91 9810929744 dilipan...@gmail.com dilipan...@yahoo.com New Delhi - 110062 On Thu, Jul 16, 2009 at 8:53 AM, Mahesh mahender.bi...@gmail.com wrote: Hi Dilip, thanx for your prompt reply but it not working. Can you send my the xls sheet. Rgds, Mahesh On Wed, Jul 15, 2009 at 7:30 PM, Dilip Pandey dilipan...@gmail.comwrote: Hi Mahesh, Open the code and repeat the following line twice (i.e. one more time) as it is already there in the code:- Selection.EntireRow.insert Thanks DILipandey (Back from Holidays) -- DILIP KUMAR PANDEY MBA-HR,B COM(Hons.),BCA Mobile: +91 9810929744 dilipan...@gmail.com dilipan...@yahoo.com New Delhi - 110062 On Wed, Jul 15, 2009 at 5:49 AM, Mahesh mahender.bi...@gmail.comwrote: Thanx, What chage should i do to insert two rows at ones. Thanx again On Wed, Jul 15, 2009 at 4:27 PM, Dilip Pandey dilipan...@gmail.com wrote: Hi Mahesh, Please find the attached file with Macro. Thanks Dilipandey (Back from Holidays) -- DILIP KUMAR PANDEY MBA-HR,B COM(Hons.),BCA Mobile: +91 9810929744 dilipan...@gmail.com dilipan...@yahoo.com New Delhi - 110062 On Wed, Jul 15, 2009 at 9:04 AM, Mahesh mahender.bi...@gmail.com wrote: Hi folks, Gud Morning I want insert empty row between the rows containing data with the hepl of macro. Please also suggested how to use it in Excel 2007. Thanks in advance... -- With Love, Mahesh Bisht -- With Love, Mahesh Bisht -- With Love, Mahesh Bisht -- With Love, Mahesh Bisht -- With Love, Mahesh Bisht -- With Love, Mahesh Bisht --~--~-~--~~~---~--~~ -- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com HELP US GROW !! We reach over 5,000 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -~--~~~~--~~--~--~---
$$Excel-Macros$$ Re: Creating empty rows b/w filed rows without ASAP
Hi Mahesh, now do UpArrow - means press up arrow key of your keyboard and press CTRL + Enter. For your convienience, entire process is explained below:- Select the data, leaving headings Press F5 Press Alt + s Press k Press Enter Press Up Arrow Press Ctrl + Enter Thanks Best Regards, DILipandey (Back from Holidays) -- DILIP KUMAR PANDEY MBA-HR,B COM(Hons.),BCA Mobile: +91 9810929744 dilipan...@gmail.com dilipan...@yahoo.com New Delhi - 110062 Press F5 - Alt + S - k - hit enter. Now do UpArrow and press Ctrl + Enter). On Thu, Jul 16, 2009 at 3:17 PM, Mahesh mahender.bi...@gmail.com wrote: Hi Dilip, What do u mean by now do UpArrow , unable to understand. Rgds, Mahender Bisht On Thu, Jul 16, 2009 at 3:04 PM, Dilip Pandey dilipan...@gmail.comwrote: *Dear Mahesh,* According to me, the best way is to follow the below method:- Select the blank region (cells), right below the data headings. (Press F5 - Alt + S - k - hit enter. Now do UpArrow and press Ctrl + Enter). It will fill out the blank cells with the data from above row. If you want you can share the spreadsheet with the group as well, so that we can do it and then you can check the results. Thanks, DILipandey (Back from Holidays) -- DILIP KUMAR PANDEY MBA-HR,B COM(Hons.),BCA Mobile: +91 9810929744 dilipan...@gmail.com dilipan...@yahoo.com New Delhi - 110062 On Thu, Jul 16, 2009 at 1:08 PM, Mahesh mahender.bi...@gmail.comwrote: Hi, Now i also want to copy data from the above row , kindly provide the code And syntax. Thanx in advanc On Thu, Jul 16, 2009 at 12:48 PM, Mahesh mahender.bi...@gmail.comwrote: Thanx bor On Thu, Jul 16, 2009 at 12:47 PM, Dilip Pandey dilipan...@gmail.comwrote: Hi Maehsh, Your requirement is attached herewith. Thanks, DILipandey (Back from Holidays) -- DILIP KUMAR PANDEY MBA-HR,B COM(Hons.),BCA Mobile: +91 9810929744 dilipan...@gmail.com dilipan...@yahoo.com New Delhi - 110062 On Thu, Jul 16, 2009 at 8:53 AM, Mahesh mahender.bi...@gmail.com wrote: Hi Dilip, thanx for your prompt reply but it not working. Can you send my the xls sheet. Rgds, Mahesh On Wed, Jul 15, 2009 at 7:30 PM, Dilip Pandey dilipan...@gmail.com wrote: Hi Mahesh, Open the code and repeat the following line twice (i.e. one more time) as it is already there in the code:- Selection.EntireRow.insert Thanks DILipandey (Back from Holidays) -- DILIP KUMAR PANDEY MBA-HR,B COM(Hons.),BCA Mobile: +91 9810929744 dilipan...@gmail.com dilipan...@yahoo.com New Delhi - 110062 On Wed, Jul 15, 2009 at 5:49 AM, Mahesh mahender.bi...@gmail.comwrote: Thanx, What chage should i do to insert two rows at ones. Thanx again On Wed, Jul 15, 2009 at 4:27 PM, Dilip Pandey dilipan...@gmail.com wrote: Hi Mahesh, Please find the attached file with Macro. Thanks Dilipandey (Back from Holidays) -- DILIP KUMAR PANDEY MBA-HR,B COM(Hons.),BCA Mobile: +91 9810929744 dilipan...@gmail.com dilipan...@yahoo.com New Delhi - 110062 On Wed, Jul 15, 2009 at 9:04 AM, Mahesh mahender.bi...@gmail.com wrote: Hi folks, Gud Morning I want insert empty row between the rows containing data with the hepl of macro. Please also suggested how to use it in Excel 2007. Thanks in advance... -- With Love, Mahesh Bisht -- With Love, Mahesh Bisht -- With Love, Mahesh Bisht -- With Love, Mahesh Bisht -- With Love, Mahesh Bisht -- With Love, Mahesh Bisht --~--~-~--~~~---~--~~ -- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com HELP US GROW !! We reach over 5,000 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -~--~~~~--~~--~--~---
$$Excel-Macros$$ Re: Creating empty rows b/w filed rows without ASAP
Hi Dilip, But when i pressed up arrow the selection automatical removed for the sheet. Rgds, Mahender Bisht On Thu, Jul 16, 2009 at 4:26 PM, Dilip Pandey dilipan...@gmail.com wrote: Hi Mahesh, now do UpArrow - means press up arrow key of your keyboard and press CTRL + Enter. For your convienience, entire process is explained below:- Select the data, leaving headings Press F5 Press Alt + s Press k Press Enter Press Up Arrow Press Ctrl + Enter Thanks Best Regards, DILipandey (Back from Holidays) -- DILIP KUMAR PANDEY MBA-HR,B COM(Hons.),BCA Mobile: +91 9810929744 dilipan...@gmail.com dilipan...@yahoo.com New Delhi - 110062 Press F5 - Alt + S - k - hit enter. Now do UpArrow and press Ctrl + Enter). On Thu, Jul 16, 2009 at 3:17 PM, Mahesh mahender.bi...@gmail.comwrote: Hi Dilip, What do u mean by now do UpArrow , unable to understand. Rgds, Mahender Bisht On Thu, Jul 16, 2009 at 3:04 PM, Dilip Pandey dilipan...@gmail.comwrote: *Dear Mahesh,* According to me, the best way is to follow the below method:- Select the blank region (cells), right below the data headings. (Press F5 - Alt + S - k - hit enter. Now do UpArrow and press Ctrl + Enter). It will fill out the blank cells with the data from above row. If you want you can share the spreadsheet with the group as well, so that we can do it and then you can check the results. Thanks, DILipandey (Back from Holidays) -- DILIP KUMAR PANDEY MBA-HR,B COM(Hons.),BCA Mobile: +91 9810929744 dilipan...@gmail.com dilipan...@yahoo.com New Delhi - 110062 On Thu, Jul 16, 2009 at 1:08 PM, Mahesh mahender.bi...@gmail.comwrote: Hi, Now i also want to copy data from the above row , kindly provide the code And syntax. Thanx in advanc On Thu, Jul 16, 2009 at 12:48 PM, Mahesh mahender.bi...@gmail.comwrote: Thanx bor On Thu, Jul 16, 2009 at 12:47 PM, Dilip Pandey dilipan...@gmail.comwrote: Hi Maehsh, Your requirement is attached herewith. Thanks, DILipandey (Back from Holidays) -- DILIP KUMAR PANDEY MBA-HR,B COM(Hons.),BCA Mobile: +91 9810929744 dilipan...@gmail.com dilipan...@yahoo.com New Delhi - 110062 On Thu, Jul 16, 2009 at 8:53 AM, Mahesh mahender.bi...@gmail.com wrote: Hi Dilip, thanx for your prompt reply but it not working. Can you send my the xls sheet. Rgds, Mahesh On Wed, Jul 15, 2009 at 7:30 PM, Dilip Pandey dilipan...@gmail.com wrote: Hi Mahesh, Open the code and repeat the following line twice (i.e. one more time) as it is already there in the code:- Selection.EntireRow.insert Thanks DILipandey (Back from Holidays) -- DILIP KUMAR PANDEY MBA-HR,B COM(Hons.),BCA Mobile: +91 9810929744 dilipan...@gmail.com dilipan...@yahoo.com New Delhi - 110062 On Wed, Jul 15, 2009 at 5:49 AM, Mahesh mahender.bi...@gmail.com wrote: Thanx, What chage should i do to insert two rows at ones. Thanx again On Wed, Jul 15, 2009 at 4:27 PM, Dilip Pandey dilipan...@gmail.com wrote: Hi Mahesh, Please find the attached file with Macro. Thanks Dilipandey (Back from Holidays) -- DILIP KUMAR PANDEY MBA-HR,B COM(Hons.),BCA Mobile: +91 9810929744 dilipan...@gmail.com dilipan...@yahoo.com New Delhi - 110062 On Wed, Jul 15, 2009 at 9:04 AM, Mahesh mahender.bi...@gmail.com wrote: Hi folks, Gud Morning I want insert empty row between the rows containing data with the hepl of macro. Please also suggested how to use it in Excel 2007. Thanks in advance... -- With Love, Mahesh Bisht -- With Love, Mahesh Bisht -- With Love, Mahesh Bisht -- With Love, Mahesh Bisht -- With Love, Mahesh Bisht -- With Love, Mahesh Bisht -- With Love, Mahesh Bisht --~--~-~--~~~---~--~~ -- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com HELP US GROW !! We reach over 5,000 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -~--~~~~--~~--~--~---
$$Excel-Macros$$ Re: Creating empty rows b/w filed rows without ASAP
hi Dilip, I am using Excel 2007. On Thu, Jul 16, 2009 at 5:10 PM, Mahesh mahender.bi...@gmail.com wrote: Hi Dilip, But when i pressed up arrow the selection automatical removed for the sheet. Rgds, Mahender Bisht On Thu, Jul 16, 2009 at 4:26 PM, Dilip Pandey dilipan...@gmail.comwrote: Hi Mahesh, now do UpArrow - means press up arrow key of your keyboard and press CTRL + Enter. For your convienience, entire process is explained below:- Select the data, leaving headings Press F5 Press Alt + s Press k Press Enter Press Up Arrow Press Ctrl + Enter Thanks Best Regards, DILipandey (Back from Holidays) -- DILIP KUMAR PANDEY MBA-HR,B COM(Hons.),BCA Mobile: +91 9810929744 dilipan...@gmail.com dilipan...@yahoo.com New Delhi - 110062 Press F5 - Alt + S - k - hit enter. Now do UpArrow and press Ctrl + Enter). On Thu, Jul 16, 2009 at 3:17 PM, Mahesh mahender.bi...@gmail.comwrote: Hi Dilip, What do u mean by now do UpArrow , unable to understand. Rgds, Mahender Bisht On Thu, Jul 16, 2009 at 3:04 PM, Dilip Pandey dilipan...@gmail.comwrote: *Dear Mahesh,* According to me, the best way is to follow the below method:- Select the blank region (cells), right below the data headings. (Press F5 - Alt + S - k - hit enter. Now do UpArrow and press Ctrl + Enter). It will fill out the blank cells with the data from above row. If you want you can share the spreadsheet with the group as well, so that we can do it and then you can check the results. Thanks, DILipandey (Back from Holidays) -- DILIP KUMAR PANDEY MBA-HR,B COM(Hons.),BCA Mobile: +91 9810929744 dilipan...@gmail.com dilipan...@yahoo.com New Delhi - 110062 On Thu, Jul 16, 2009 at 1:08 PM, Mahesh mahender.bi...@gmail.comwrote: Hi, Now i also want to copy data from the above row , kindly provide the code And syntax. Thanx in advanc On Thu, Jul 16, 2009 at 12:48 PM, Mahesh mahender.bi...@gmail.comwrote: Thanx bor On Thu, Jul 16, 2009 at 12:47 PM, Dilip Pandey dilipan...@gmail.comwrote: Hi Maehsh, Your requirement is attached herewith. Thanks, DILipandey (Back from Holidays) -- DILIP KUMAR PANDEY MBA-HR,B COM(Hons.),BCA Mobile: +91 9810929744 dilipan...@gmail.com dilipan...@yahoo.com New Delhi - 110062 On Thu, Jul 16, 2009 at 8:53 AM, Mahesh mahender.bi...@gmail.com wrote: Hi Dilip, thanx for your prompt reply but it not working. Can you send my the xls sheet. Rgds, Mahesh On Wed, Jul 15, 2009 at 7:30 PM, Dilip Pandey dilipan...@gmail.com wrote: Hi Mahesh, Open the code and repeat the following line twice (i.e. one more time) as it is already there in the code:- Selection.EntireRow.insert Thanks DILipandey (Back from Holidays) -- DILIP KUMAR PANDEY MBA-HR,B COM(Hons.),BCA Mobile: +91 9810929744 dilipan...@gmail.com dilipan...@yahoo.com New Delhi - 110062 On Wed, Jul 15, 2009 at 5:49 AM, Mahesh mahender.bi...@gmail.com wrote: Thanx, What chage should i do to insert two rows at ones. Thanx again On Wed, Jul 15, 2009 at 4:27 PM, Dilip Pandey dilipan...@gmail.com wrote: Hi Mahesh, Please find the attached file with Macro. Thanks Dilipandey (Back from Holidays) -- DILIP KUMAR PANDEY MBA-HR,B COM(Hons.),BCA Mobile: +91 9810929744 dilipan...@gmail.com dilipan...@yahoo.com New Delhi - 110062 On Wed, Jul 15, 2009 at 9:04 AM, Mahesh mahender.bi...@gmail.com wrote: Hi folks, Gud Morning I want insert empty row between the rows containing data with the hepl of macro. Please also suggested how to use it in Excel 2007. Thanks in advance... -- With Love, Mahesh Bisht -- With Love, Mahesh Bisht -- With Love, Mahesh Bisht -- With Love, Mahesh Bisht -- With Love, Mahesh Bisht -- With Love, Mahesh Bisht -- With Love, Mahesh Bisht -- With Love, Mahesh Bisht --~--~-~--~~~---~--~~ -- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com HELP US GROW !! We reach over 5,000 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -~--~~~~--~~--~--~---
$$Excel-Macros$$ Re: Creating empty rows b/w filed rows without ASAP
Dear Mahesh, It will be good to explain, if you can share the test worksheet with us (having relevant data portion). Thanks DILipandey (Back from Holidays) -- DILIP KUMAR PANDEY MBA-HR,B COM(Hons.),BCA Mobile: +91 9810929744 dilipan...@gmail.com dilipan...@yahoo.com New Delhi - 110062 On Thu, Jul 16, 2009 at 5:15 PM, Mahesh mahender.bi...@gmail.com wrote: hi Dilip, I am using Excel 2007. On Thu, Jul 16, 2009 at 5:10 PM, Mahesh mahender.bi...@gmail.com wrote: Hi Dilip, But when i pressed up arrow the selection automatical removed for the sheet. Rgds, Mahender Bisht On Thu, Jul 16, 2009 at 4:26 PM, Dilip Pandey dilipan...@gmail.comwrote: Hi Mahesh, now do UpArrow - means press up arrow key of your keyboard and press CTRL + Enter. For your convienience, entire process is explained below:- Select the data, leaving headings Press F5 Press Alt + s Press k Press Enter Press Up Arrow Press Ctrl + Enter Thanks Best Regards, DILipandey (Back from Holidays) -- DILIP KUMAR PANDEY MBA-HR,B COM(Hons.),BCA Mobile: +91 9810929744 dilipan...@gmail.com dilipan...@yahoo.com New Delhi - 110062 Press F5 - Alt + S - k - hit enter. Now do UpArrow and press Ctrl + Enter). On Thu, Jul 16, 2009 at 3:17 PM, Mahesh mahender.bi...@gmail.comwrote: Hi Dilip, What do u mean by now do UpArrow , unable to understand. Rgds, Mahender Bisht On Thu, Jul 16, 2009 at 3:04 PM, Dilip Pandey dilipan...@gmail.comwrote: *Dear Mahesh,* According to me, the best way is to follow the below method:- Select the blank region (cells), right below the data headings. (Press F5 - Alt + S - k - hit enter. Now do UpArrow and press Ctrl + Enter). It will fill out the blank cells with the data from above row. If you want you can share the spreadsheet with the group as well, so that we can do it and then you can check the results. Thanks, DILipandey (Back from Holidays) -- DILIP KUMAR PANDEY MBA-HR,B COM(Hons.),BCA Mobile: +91 9810929744 dilipan...@gmail.com dilipan...@yahoo.com New Delhi - 110062 On Thu, Jul 16, 2009 at 1:08 PM, Mahesh mahender.bi...@gmail.comwrote: Hi, Now i also want to copy data from the above row , kindly provide the code And syntax. Thanx in advanc On Thu, Jul 16, 2009 at 12:48 PM, Mahesh mahender.bi...@gmail.comwrote: Thanx bor On Thu, Jul 16, 2009 at 12:47 PM, Dilip Pandey dilipan...@gmail.com wrote: Hi Maehsh, Your requirement is attached herewith. Thanks, DILipandey (Back from Holidays) -- DILIP KUMAR PANDEY MBA-HR,B COM(Hons.),BCA Mobile: +91 9810929744 dilipan...@gmail.com dilipan...@yahoo.com New Delhi - 110062 On Thu, Jul 16, 2009 at 8:53 AM, Mahesh mahender.bi...@gmail.com wrote: Hi Dilip, thanx for your prompt reply but it not working. Can you send my the xls sheet. Rgds, Mahesh On Wed, Jul 15, 2009 at 7:30 PM, Dilip Pandey dilipan...@gmail.com wrote: Hi Mahesh, Open the code and repeat the following line twice (i.e. one more time) as it is already there in the code:- Selection.EntireRow.insert Thanks DILipandey (Back from Holidays) -- DILIP KUMAR PANDEY MBA-HR,B COM(Hons.),BCA Mobile: +91 9810929744 dilipan...@gmail.com dilipan...@yahoo.com New Delhi - 110062 On Wed, Jul 15, 2009 at 5:49 AM, Mahesh mahender.bi...@gmail.com wrote: Thanx, What chage should i do to insert two rows at ones. Thanx again On Wed, Jul 15, 2009 at 4:27 PM, Dilip Pandey dilipan...@gmail.com wrote: Hi Mahesh, Please find the attached file with Macro. Thanks Dilipandey (Back from Holidays) -- DILIP KUMAR PANDEY MBA-HR,B COM(Hons.),BCA Mobile: +91 9810929744 dilipan...@gmail.com dilipan...@yahoo.com New Delhi - 110062 On Wed, Jul 15, 2009 at 9:04 AM, Mahesh mahender.bi...@gmail.com wrote: Hi folks, Gud Morning I want insert empty row between the rows containing data with the hepl of macro. Please also suggested how to use it in Excel 2007. Thanks in advance... -- With Love, Mahesh Bisht -- With Love, Mahesh Bisht -- With Love, Mahesh Bisht -- With Love, Mahesh Bisht -- With Love, Mahesh Bisht -- With Love, Mahesh Bisht -- With Love, Mahesh Bisht -- With Love, Mahesh Bisht --~--~-~--~~~---~--~~ -- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com HELP US
$$Excel-Macros$$ Re: Creating empty rows b/w filed rows without ASAP
Hi Dili, Gud Morning, I using the same file which is already attached. On Thu, Jul 16, 2009 at 5:42 PM, Dilip Pandey dilipan...@gmail.com wrote: Dear Mahesh, It will be good to explain, if you can share the test worksheet with us (having relevant data portion). Thanks DILipandey (Back from Holidays) -- DILIP KUMAR PANDEY MBA-HR,B COM(Hons.),BCA Mobile: +91 9810929744 dilipan...@gmail.com dilipan...@yahoo.com New Delhi - 110062 On Thu, Jul 16, 2009 at 5:15 PM, Mahesh mahender.bi...@gmail.comwrote: hi Dilip, I am using Excel 2007. On Thu, Jul 16, 2009 at 5:10 PM, Mahesh mahender.bi...@gmail.com wrote: Hi Dilip, But when i pressed up arrow the selection automatical removed for the sheet. Rgds, Mahender Bisht On Thu, Jul 16, 2009 at 4:26 PM, Dilip Pandey dilipan...@gmail.comwrote: Hi Mahesh, now do UpArrow - means press up arrow key of your keyboard and press CTRL + Enter. For your convienience, entire process is explained below:- Select the data, leaving headings Press F5 Press Alt + s Press k Press Enter Press Up Arrow Press Ctrl + Enter Thanks Best Regards, DILipandey (Back from Holidays) -- DILIP KUMAR PANDEY MBA-HR,B COM(Hons.),BCA Mobile: +91 9810929744 dilipan...@gmail.com dilipan...@yahoo.com New Delhi - 110062 Press F5 - Alt + S - k - hit enter. Now do UpArrow and press Ctrl + Enter). On Thu, Jul 16, 2009 at 3:17 PM, Mahesh mahender.bi...@gmail.comwrote: Hi Dilip, What do u mean by now do UpArrow , unable to understand. Rgds, Mahender Bisht On Thu, Jul 16, 2009 at 3:04 PM, Dilip Pandey dilipan...@gmail.comwrote: *Dear Mahesh,* According to me, the best way is to follow the below method:- Select the blank region (cells), right below the data headings. (Press F5 - Alt + S - k - hit enter. Now do UpArrow and press Ctrl + Enter). It will fill out the blank cells with the data from above row. If you want you can share the spreadsheet with the group as well, so that we can do it and then you can check the results. Thanks, DILipandey (Back from Holidays) -- DILIP KUMAR PANDEY MBA-HR,B COM(Hons.),BCA Mobile: +91 9810929744 dilipan...@gmail.com dilipan...@yahoo.com New Delhi - 110062 On Thu, Jul 16, 2009 at 1:08 PM, Mahesh mahender.bi...@gmail.comwrote: Hi, Now i also want to copy data from the above row , kindly provide the code And syntax. Thanx in advanc On Thu, Jul 16, 2009 at 12:48 PM, Mahesh mahender.bi...@gmail.com wrote: Thanx bor On Thu, Jul 16, 2009 at 12:47 PM, Dilip Pandey dilipan...@gmail.com wrote: Hi Maehsh, Your requirement is attached herewith. Thanks, DILipandey (Back from Holidays) -- DILIP KUMAR PANDEY MBA-HR,B COM(Hons.),BCA Mobile: +91 9810929744 dilipan...@gmail.com dilipan...@yahoo.com New Delhi - 110062 On Thu, Jul 16, 2009 at 8:53 AM, Mahesh mahender.bi...@gmail.com wrote: Hi Dilip, thanx for your prompt reply but it not working. Can you send my the xls sheet. Rgds, Mahesh On Wed, Jul 15, 2009 at 7:30 PM, Dilip Pandey dilipan...@gmail.com wrote: Hi Mahesh, Open the code and repeat the following line twice (i.e. one more time) as it is already there in the code:- Selection.EntireRow.insert Thanks DILipandey (Back from Holidays) -- DILIP KUMAR PANDEY MBA-HR,B COM(Hons.),BCA Mobile: +91 9810929744 dilipan...@gmail.com dilipan...@yahoo.com New Delhi - 110062 On Wed, Jul 15, 2009 at 5:49 AM, Mahesh mahender.bi...@gmail.com wrote: Thanx, What chage should i do to insert two rows at ones. Thanx again On Wed, Jul 15, 2009 at 4:27 PM, Dilip Pandey dilipan...@gmail.com wrote: Hi Mahesh, Please find the attached file with Macro. Thanks Dilipandey (Back from Holidays) -- DILIP KUMAR PANDEY MBA-HR,B COM(Hons.),BCA Mobile: +91 9810929744 dilipan...@gmail.com dilipan...@yahoo.com New Delhi - 110062 On Wed, Jul 15, 2009 at 9:04 AM, Mahesh mahender.bi...@gmail.com wrote: Hi folks, Gud Morning I want insert empty row between the rows containing data with the hepl of macro. Please also suggested how to use it in Excel 2007. Thanks in advance... -- With Love, Mahesh Bisht -- With Love, Mahesh Bisht -- With Love, Mahesh Bisht -- With Love, Mahesh Bisht -- With Love, Mahesh Bisht -- With Love, Mahesh Bisht -- With Love, Mahesh Bisht -- With Love, Mahesh Bisht -- With Love, Mahesh Bisht --~--~-~--~~~---~--~~ -- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this
$$Excel-Macros$$ Re: Creating empty rows b/w filed rows without ASAP
Hi Mahesh Simply Select the Row and press ctrl + .. each + will add one row... given below is the macro for the same.. just select any cell in the row above which you want the new rows... == Sub InsertMultipleRows() number_of_rows = InputBox(Prompt:=How many rows do you want to insert?) For n = 1 To number_of_rows Selection.EntireRow.Insert , CopyOrigin:=xlFormatFromLeftOrAbove Next n End Sub == hope this helps Regards, Vivek Agrawal Skype ID - vivek.agrawal83 GoogleMoonlight.com - Saving energy-Save Earth On Wed, Jul 15, 2009 at 9:04 AM, Mahesh mahender.bi...@gmail.com wrote: Hi folks, Gud Morning I want insert empty row between the rows containing data with the hepl of macro. Please also suggested how to use it in Excel 2007. Thanks in advance... -- With Love, Mahesh Bisht --~--~-~--~~~---~--~~ -- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com HELP US GROW !! We reach over 5,000 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -~--~~~~--~~--~--~---
$$Excel-Macros$$ Re: Creating empty rows b/w filed rows without ASAP
Hi Mahesh, Insert the below code in a new module. '___ ___ Sub Macro1() Range(A1).Activate ' Change A1 to Starting of Your Data and the column having maximum no of non blank cells so that the macro should run till the end of your data. Do While ActiveCell.Value Rows(ActiveCell.Row).Offset(1, 0).Select Selection.Insert Shift:=xlDown ' Repeat This line of Code to the no of blank Rows you need. ActiveCell.Offset(1, 0).Activate Loop End Sub ___ Regards, Upendra Singh +91-9910227325, +91-9310760597 - There are 10 kinds of people: Those who understand binary and those who don't. - From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com] On Behalf Of Mahesh Sent: Wednesday, July 15, 2009 9:05 AM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Creating empty rows b/w filed rows without ASAP Hi folks, Gud Morning I want insert empty row between the rows containing data with the hepl of macro. Please also suggested how to use it in Excel 2007. Thanks in advance... -- With Love, Mahesh Bisht --~--~-~--~~~---~--~~ -- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com HELP US GROW !! We reach over 5,000 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -~--~~~~--~~--~--~---
$$Excel-Macros$$ Re: Creating empty rows b/w filed rows without ASAP
Hi Mahesh, Please find the attached file with Macro. Thanks Dilipandey (Back from Holidays) -- DILIP KUMAR PANDEY MBA-HR,B COM(Hons.),BCA Mobile: +91 9810929744 dilipan...@gmail.com dilipan...@yahoo.com New Delhi - 110062 On Wed, Jul 15, 2009 at 9:04 AM, Mahesh mahender.bi...@gmail.com wrote: Hi folks, Gud Morning I want insert empty row between the rows containing data with the hepl of macro. Please also suggested how to use it in Excel 2007. Thanks in advance... -- With Love, Mahesh Bisht --~--~-~--~~~---~--~~ -- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com HELP US GROW !! We reach over 5,000 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -~--~~~~--~~--~--~--- Insert Rows -By DILipandey.xls Description: MS-Excel spreadsheet
$$Excel-Macros$$ Re: Creating empty rows b/w filed rows without ASAP
Thanx, What chage should i do to insert two rows at ones. Thanx again On Wed, Jul 15, 2009 at 4:27 PM, Dilip Pandey dilipan...@gmail.com wrote: Hi Mahesh, Please find the attached file with Macro. Thanks Dilipandey (Back from Holidays) -- DILIP KUMAR PANDEY MBA-HR,B COM(Hons.),BCA Mobile: +91 9810929744 dilipan...@gmail.com dilipan...@yahoo.com New Delhi - 110062 On Wed, Jul 15, 2009 at 9:04 AM, Mahesh mahender.bi...@gmail.comwrote: Hi folks, Gud Morning I want insert empty row between the rows containing data with the hepl of macro. Please also suggested how to use it in Excel 2007. Thanks in advance... -- With Love, Mahesh Bisht -- With Love, Mahesh Bisht --~--~-~--~~~---~--~~ -- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com HELP US GROW !! We reach over 5,000 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -~--~~~~--~~--~--~---
$$Excel-Macros$$ Re: Creating empty rows b/w filed rows without ASAP
Hi Mahesh, Open the code and repeat the following line twice (i.e. one more time) as it is already there in the code:- Selection.EntireRow.insert Thanks DILipandey (Back from Holidays) -- DILIP KUMAR PANDEY MBA-HR,B COM(Hons.),BCA Mobile: +91 9810929744 dilipan...@gmail.com dilipan...@yahoo.com New Delhi - 110062 On Wed, Jul 15, 2009 at 5:49 AM, Mahesh mahender.bi...@gmail.com wrote: Thanx, What chage should i do to insert two rows at ones. Thanx again On Wed, Jul 15, 2009 at 4:27 PM, Dilip Pandey dilipan...@gmail.comwrote: Hi Mahesh, Please find the attached file with Macro. Thanks Dilipandey (Back from Holidays) -- DILIP KUMAR PANDEY MBA-HR,B COM(Hons.),BCA Mobile: +91 9810929744 dilipan...@gmail.com dilipan...@yahoo.com New Delhi - 110062 On Wed, Jul 15, 2009 at 9:04 AM, Mahesh mahender.bi...@gmail.comwrote: Hi folks, Gud Morning I want insert empty row between the rows containing data with the hepl of macro. Please also suggested how to use it in Excel 2007. Thanks in advance... -- With Love, Mahesh Bisht -- With Love, Mahesh Bisht --~--~-~--~~~---~--~~ -- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com HELP US GROW !! We reach over 5,000 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -~--~~~~--~~--~--~---
$$Excel-Macros$$ Re: Creating empty rows b/w filed rows without ASAP
Hi Dilip, thanx for your prompt reply but it not working. Can you send my the xls sheet. Rgds, Mahesh On Wed, Jul 15, 2009 at 7:30 PM, Dilip Pandey dilipan...@gmail.com wrote: Hi Mahesh, Open the code and repeat the following line twice (i.e. one more time) as it is already there in the code:- Selection.EntireRow.insert Thanks DILipandey (Back from Holidays) -- DILIP KUMAR PANDEY MBA-HR,B COM(Hons.),BCA Mobile: +91 9810929744 dilipan...@gmail.com dilipan...@yahoo.com New Delhi - 110062 On Wed, Jul 15, 2009 at 5:49 AM, Mahesh mahender.bi...@gmail.comwrote: Thanx, What chage should i do to insert two rows at ones. Thanx again On Wed, Jul 15, 2009 at 4:27 PM, Dilip Pandey dilipan...@gmail.comwrote: Hi Mahesh, Please find the attached file with Macro. Thanks Dilipandey (Back from Holidays) -- DILIP KUMAR PANDEY MBA-HR,B COM(Hons.),BCA Mobile: +91 9810929744 dilipan...@gmail.com dilipan...@yahoo.com New Delhi - 110062 On Wed, Jul 15, 2009 at 9:04 AM, Mahesh mahender.bi...@gmail.comwrote: Hi folks, Gud Morning I want insert empty row between the rows containing data with the hepl of macro. Please also suggested how to use it in Excel 2007. Thanks in advance... -- With Love, Mahesh Bisht -- With Love, Mahesh Bisht -- With Love, Mahesh Bisht --~--~-~--~~~---~--~~ -- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com HELP US GROW !! We reach over 5,000 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -~--~~~~--~~--~--~---