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:="H
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 maxim
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 wrote:
> Hi folks,
>
> Gud M
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 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
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.
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 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:-
>
> Selecti
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 wrote:
> Hi Dilip,
>
> thanx
Thanx bor
On Thu, Jul 16, 2009 at 12:47 PM, Dilip Pandey 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
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 wrote:
> Thanx bor
>
>
> On Thu, Jul 16, 2009 at 12:47 PM, Dilip Pandey wrote:
>
>> Hi Maehsh,
>>
>> Your requirement is attached herewith.
*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 wan
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 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.
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,
DILipand
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 wrote:
> Hi Mahesh,
>
> now do UpArrow -> means press up arrow key of your keyboard and press CTRL
> + Enter.
> For your convienience, enti
hi Dilip,
I am using Excel 2007.
On Thu, Jul 16, 2009 at 5:10 PM, Mahesh 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 wrote:
>
>> Hi Mahesh,
>>
>> now do Up
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 T
Hi Dili,
Gud Morning,
I using the same file which is already attached.
On Thu, Jul 16, 2009 at 5:42 PM, Dilip Pandey 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 Holiday
Thanx dilip,
my problem is solved.
A learn a lot form u.
rgds,
Mahesh
On Fri, Jul 17, 2009 at 8:42 AM, Mahesh 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 wrote:
>
>> Dear Mahesh,
>>
>> It will
17 matches
Mail list logo