Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Wanet Telecoms Ltd on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: dnky
  • Content: Threads
  • Order by date
  1. dnky

    "Syntax Error" on Redim of sub of jagged array (Excel XP)

    I need some help and I can't find the answer elsewhere on here or anywhere. I'm using jagged arrays to store information, I declared it as so: Dim mainArray() As Variant, subArray() As Variant ... Redim mainArray(1 To 5) Redim subArray(1 To 5) mainArray(1) = subArray ... and later when I need...
  2. dnky

    Excel VBA - crazy re-re-re-recalculating during save

    I've written a function which takes a range of usually a few thousand cells, puts them in an array, sorts them and finds a particular located cell and returns that value. The sorting takes a moment to complete so the calculation usually takes approx a second. Then I noticed that automatic...
  3. dnky

    Powerpoint - Macro to run custom show - Not Working

    I've got a "menu" slide with all the custom shows assigned to buttons. I need to style the buttons as "visited" once clicked but I can't assign a link AND a macro to a button so I'm trying to get the macro to run the custom show. Here;s what i have (the shape name is the same as the show...
  4. dnky

    Crop the number of characters in a text string

    I'm trying to set up a macro to make custom shows in Powerpoint based on the title slides, the problem is custom show names have a limit of 32 characters. So if the title string variable contains more than 32 characters, how do I chop off the end. thank you
  5. dnky

    using raster images with transparency - screws up on export

    When i use a raster image with transparency in Freehand (i.e. an imported PNG), the vector objects beind the image's transparent area have no anti-aliasing applied when exported to a single layer image. The only time they do anti-alias is behind any raster effects - but the raster effects screw...
  6. dnky

    making Excel graph splitter - need to extract info from series formula

    Hi everybody, i'm a novice trying to write a macro for a simple graph splitter. Just one that takes the graph you're looking at and divides it up into smaller ranges. Currently i have it working on a simple loop. The problem is you have to manually input the start and end row numbers. Also...
  7. dnky

    making a simple quiz in powerpoint

    I've been pondering this one all day and thought i'd see if anyone else can help. I'm making an interactive book in powerpoint and i want a quiz at the end. Each question will have it's own slide and 4 answers to choose from. After deciding that creating an access database using a form for...

Part and Inventory Search

Back
Top