Sorry Kahlid,
I am at zero with VBA. Hope some one here will help you out.
On Friday, January 25, 2013 10:15:29 PM UTC+5:30, Sadia Khalid wrote:
>
>
> *@indu prakashany *
> any VBA code for this
>
>
--
Join official Facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RU
*@indu prakashany *
any VBA code for this
--
Join official Facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not g
*@indu prakash I know this.
the point is that i have a too bing file for which , there are missing
values. if i use a formula which is column E. i have to do a lot of eating.
whihc will take a lo lot of time. but if i use a formula which is column D
, my work can be done easily if absolute cell ad
You can't use this formula *INDIRECT(ADDRESS(ROW()-1,COLUMN()) for absolute
sell referencing, because as you will switch to next cell all the
references will change.*
*
*
*If your objective is to get the result of column D as column E, you don't
have to use this formula just enter absolute refer
@indu prakash
thanks for your reply. but how i can use this formula
*INDIRECT(ADDRESS(ROW()-1,COLUMN())
for absolute cell addressing.*
*
*
*Thanks *
*
*
*I want to convert the results of column D as Column E.*
--
Join official Facebook page of this forum @
https://www.facebook.com/discussexcel
We are getting different values in column D and E because the formula used
in column D has relative cell reference because of which references are
changing but in case of column E cells are fixed. Result of which when we
are moving to D24, in case of column D references are $D$23 but it column E
NO
its not doing this
see this file
https://skydrive.live.com/redir?resid=DD0BC148DF66DAC4!176&authkey=!ANSe4WnuJ1fhJHo
I want to get the values like in column E in colored cells , the formulas
in both the columns are same except the relative cell referencing.
--
Join official Facebook
Hi Khalid,
This will alwsy gives you absolute address
as i placed this formula In H24 and I got $H$23 which is an absolute
address
Regards
Prince
On Friday, January 25, 2013 5:26:13 PM UTC+5:30, Sadia Khalid wrote:
>
> SALAM
> Hi Every one Hope that all of you are fine.
>
> How i can use th
