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
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
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
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,
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
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
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
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
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
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
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
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
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
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
14 matches
Mail list logo