LinkBack URL
About LinkBacks
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
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
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
'_- Google first, like this _ site:ExcelForum.com Gamut
Use Code Tags: Highlight code; click on the # icon above,
Post screenshots COPYABLE to a Spredsheet; NOT IMAGES PLEASE
http://www.excelforum.com/the-water-...ml#post4109080
https://app.box.com/s/gjpa8mk8ko4vkwcke3ig2w8z2wkfvrtv
http://excelmatters.com/excel-forums/ ( Scrolll down to bottom )
no while i was uploading this threat due to server reset error it got uploaded so many times unintentially
Hi,
If you delete column C it would not be a great surprise that formulas dependent upon those cells are affected.
Don
Please remember to mark your thread 'Solved' when appropriate.
Thanks for letting us know, the Forum software is playing up a bit currentlyOriginally Posted by ROHAN999
Now plz tell me the solution of my problem
Hi ROHAN999
Maybe before deleting column C do something like this
Alan
Please Login or Register to view this content.
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
Last edited by Doc.AElstein; 10-05-2016 at 11:00 AM.
I am not getting you point sir
This formula not working getting #ref
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
Last edited by Doc.AElstein; 10-05-2016 at 02:51 PM.
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
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
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.......
_..........”.... 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:
Rem 2 ) '......delete the entire row where column d is blank"
Then AFTER isPlease Login or Register to view this content.
Row\Col
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
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
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
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_..._..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
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks