Morning Discussion

by Jeff "geedeck" Gondek, Jan 23, 2008 10:35pm PST
Related Topics – Wack News, Replay Couch

Good morning Shackers, hope the day finds you well.

Do you know how hard Nick works in the video mine every week? Let's just say he does it so you don't have to face the awful truth. Show your appreciation by checking out his latest Replay Couch . Also, Aaron brings word on some of the changes to GTA IV.

Even if you don't like the word "Blog", the results are rather nice:






























  • I need Excel help again :(

    I'm running a VBA macro. I need it to delete all the text boxes in a certain region on a graph. There's a few titles in more text boxes (they can't be moved into the graph title, they must remain in text boxes), so I can't just cycle through and delete every text box on the screen.

    Normally I just record a macro and copy the code, but if I select the region I'm trying to delete it just tells me "ActiveChart.Shapes.Range(Array("Text Box 97", "Text Box 98", "Text Box 99")). _
    Select"

    This won't work out because I need to put more Text Boxes in after I delete these, and apparently they name sequentially. So this run of the macro I might need to delete Text Box 97, 98, 99, but a few runs later they will be called Text Box 109, 110, and 111...

    Basically, is there a way to tell Excel to select everything within a region (I have to coordinates) of the screen? Alternatively, can I tell it to select ALL textboxes, and then go back and deselect the ones I don't need? Any other solutions?

    Thanks :(