PANKAJUTEKAR
Board Regular
- Joined
- Jun 10, 2011
- Messages
- 79
Sir,
I have a record in excel sheet in range (d4:i4) and many more. like (d5:i5)..(d6:i6)etc.
wht i am trying-
when i dont want data d5:i5..how do i delete it?
Problem is - in a5 a10 that contains some formula and this cell work as fix value.
whn i am delete the row it chnges the value of a5 a10 and so on.
So, is there any trick to delete only that perticular range.
by selecting one cell or any thing.
I am trying on starting cell i.e- d4 suppose.
is there click event, so only the same range wil delete and below row comes to the upper postion.
All experts, require ur kind suggestion..
I have a record in excel sheet in range (d4:i4) and many more. like (d5:i5)..(d6:i6)etc.
wht i am trying-
when i dont want data d5:i5..how do i delete it?
Problem is - in a5 a10 that contains some formula and this cell work as fix value.
whn i am delete the row it chnges the value of a5 a10 and so on.
So, is there any trick to delete only that perticular range.
by selecting one cell or any thing.
I am trying on starting cell i.e- d4 suppose.
is there click event, so only the same range wil delete and below row comes to the upper postion.
All experts, require ur kind suggestion..
