After vba use my formula stop working as the vba replaces cell values

[ROHAN999]

When my vba delete column c values and upgrade the values as per vba then my formulas in column d whose results are dependent on column c values stops working

using iferror but unable to solve

[Doc.AElstein]

Hi ROHAN999
Have you deliberately posted 4 times the same question?.
Or was this caused by the Forum Softwäre?
Did you intend posting 4 times the same question ?
Alan

[ROHAN999]

no while i was uploading this threat due to server reset error it got uploaded so many times unintentially

[xlnitwit]

Hi,

If you delete column C it would not be a great surprise that formulas dependent upon those cells are affected.

[Doc.AElstein]

no while i was uploading this threat due to server reset error it got uploaded so many times unintentially

Thanks for letting us know, the Forum software is playing up a bit currently

[ROHAN999]

Now plz tell me the solution of my problem

[Doc.AElstein]

Hi ROHAN999
Maybe before deleting column C do something like this

Please Login or Register  to view this content.

Alan

P.s.
We can only give general ideas if you only give us brief details of your problem
http://www.excelforum.com/showthread...t=#post4494031

[ROHAN999]

I am not getting you point sir

[ROHAN999]

This formula not working getting #ref

[Doc.AElstein]

Hi ROHAN999
You are not giving us enough infomation.
We cannot help you if you do not give us more detail of the problem.
We can only give general ideas if you only give us brief details of your problem.
http://www.excelforum.com/showthread...t=#post4494031
We need to see your code and / or your workbook.
You must explain to us what you want.

If you delete a column that is referenced in a formula then it is obvious that the formula will error after the column is deleted.

You must tell us what you want to happen.

My solution will replace the formulas with the value they give prior to the column being deleted.

If you wish something else to happen then you must tell us what. For example, you could move the column instead of deleting it_..

Please Login or Register  to view this content.

Alan

[ROHAN999]

In my sheet i am using a vba which have removed in sample sheet

but narrating what the vba is doing..vba delete the entire row where column d is blank

and formulas in cell l are dependent on column d

using indirect function to remove this error but unable to do it

[Doc.AElstein]

Hi ROHAN999,
Thank you for the File

Sorry, but
I still do not understand what you are doing.
I still do not understand exactly what the problem is
I still do not understand what you want.

_..................

You have supplied a File with some data in column D, and Formulas in column L which are dependent on values in column D

BEFORE: ( Reduced data example of your uploaded File )

Using Excel 2007 32 bit

Row\Col	A	B	C	D	E	F	G	H	I	J	K	L	M
1	1	2	3	4	5	6	7	8	9	10	11	12	13
2		0	#WERT!	12				#WERT!	#WERT!	#WERT!		=VALUE(D2)	0
3		0	#WERT!					#WERT!	#WERT!	#WERT!		=VALUE(D3)	0
4		0	#WERT!	45				#WERT!	#WERT!	#WERT!		=VALUE(D4)	0
5		0	#WERT!	66				#WERT!	#WERT!	#WERT!		=VALUE(D5)	0
6		0	#WERT!					#WERT!	#WERT!	#WERT!		=VALUE(D6)	0
7		0	#WERT!					#WERT!	#WERT!	#WERT!		=VALUE(D7)	0
8		0	#WERT!					#WERT!	#WERT!	#WERT!		=VALUE(D8)	0
9		0	#WERT!					#WERT!	#WERT!	#WERT!		=VALUE(D9)	0
10		0	#WERT!					#WERT!	#WERT!	#WERT!		=VALUE(D10)	0
11

Sheet1

_.........

I still do not understand exactly what you are doing.
I still do not understand exactly what the problem is
I still do not understand what you want.

_....Next post.......

[Doc.AElstein]

_..........”.... from last Post........”....


I still do not understand exactly what you are doing.
I still do not understand exactly what the problem is
I still do not understand what you want.

_.......

Following what you say:

...vba is doing..vba delete the entire row where column d is blank
and formulas in cell l are dependent on column d...

Rem 2 ) '......delete the entire row where column d is blank"

Please Login or Register  to view this content.

Then AFTER is

Row\Col	A	B	C	D	E	F	G	H	I	J	K	L	M
1	1	2	3	4	5	6	7	8	9	10	11	12	13
2		0	#WERT!	12				#WERT!	#WERT!	#WERT!		=VALUE(D2)	0
3		0	#WERT!	45				#WERT!	#WERT!	#WERT!		=VALUE(D3)	0
4		0	#WERT!	66				#WERT!	#WERT!	#WERT!		=VALUE(D4)	0
5

Sheet1

_.. I bet my Willy you do not want that. So you show me now what AFTER you do want. And / or try again to explain.....

Alan

[ROHAN999]

now attached sample with my code

click on code and check that errors are coming in coumn l and m

how to solve it


as i am indirect function to solve but as the source change it does not help

kindly assisst now

[ROHAN999]

oh i solved it by changing the position of o7 to o8

done it but any ways thanks

i will again ask for assisstance on this project if require so not closing this threat till then plz bear and assisst if anything will be required i will ask else i will close this thread

[Doc.AElstein]

Hi ROHAN999
Thanks for letting us know

In future please help us to help you by giving a good description and code and sample data from the outset
From your initial descriptions it was totally impossible to have had any Idea what so ever of your problem
My efforts were wasted as I was addressing a completely different problem to that indicated by your very brief and incomplete descriptions of the problem

I appreciate that you may have difficulties in communicating in English. But it is essential if you require further assistance to greatly improve on your description of the problem


Also, once again, this_...

oh i solved it by changing the position of o7 to o8...

_..tells us nothing. You are again addressing something or some problem or some aspect of some problem. Nobody can follow or understand you


Please remember that we cannot read your mind


Alan