LinkBack URL
About LinkBacks
I've been trying to wrap my brain around this and just can't figure it out.!.
Col, G:1 - G:100
I want to have a macro that will clear all contents (function) of these cells that have #VALUE!...
pls help!
I've been trying to wrap my brain around this and just can't figure it out.!.
Col, G:1 - G:100
I want to have a macro that will clear all contents (function) of these cells that have #VALUE!...
pls help!
Last edited by hzppby; 03-20-2012 at 01:41 AM.
Hi hzppby,
If you have formulas in G1 to G100 and #value is appearing as some of the results, would suggest you to use error handlers function.. i.e., =if(iserror(formula),"",formula)
Post the sample file if you face any issues. Thanks.
Regards,
DILIPandey
<click on below 'star' if this helps>
DILIPandey, Excel rMVP
+919810929744 (India), +971528225509 (Dubai), dilipandey@gmail.com
I want to have a macro go threw that row and clear everything in those cells returning #value
G column
when i add what you have just returns false.
Hi hzppby,
Try this while on the 'players' tab:
HTH
Option Explicit Sub Macro1() Dim rngCell As Range Application.ScreenUpdating = False For Each rngCell In Range("G1", Range("G" & Rows.Count).End(xlUp)) If IsError(rngCell) = True Then rngCell.ClearContents End If Next rngCell Application.ScreenUpdating = True End Sub
Robert
____________________________________________
Please ensure you mark your thread as Solved once it is. Click here to see how
If this post helps, please don't forget to say thanks by clicking the star icon in the bottom left-hand corner of my post
Worked like a charm! thanks
Originally Posted by Trebor76
Hi hzppby,
Try this while on the 'players' tab:
HTHOption Explicit Sub Macro1() Dim rngCell As Range Application.ScreenUpdating = False For Each rngCell In Range("G1", Range("G" & Rows.Count).End(xlUp)) If IsError(rngCell) = True Then rngCell.ClearContents End If Next rngCell Application.ScreenUpdating = True End Sub
Robert
Hi hzppby,
See the formula applied in yellow cell in the attached file.
Also, I am not convinced with the formula you have in that column, which can be improved if you can provide the logic behind. Thanks.
Regards,
DILIPandey
<click on below 'star' if this helps>
Well i need to delete the function not being used, because one of the macros starts at the G1 and does a Shift+end+down arrow. and its still going to the end of col g100.
this is why i need a macro to delete functions not being used in this col.
Ok.. in that case check the solution provided by Robert in post #5.
cheers
Regards,
DILIPandey
<click on below 'star' if this helps>
Glad to hear it!! Make sure to mark the thread as solved when you get a chance.
Last edited by Trebor76; 03-20-2012 at 08:34 PM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks