range objects

  1. Z

    Problem with range object

    Hello, First of all, I'd like to say I am totally new to Visual Basic for Application. I have some experiences with other languages: good with C++ and Java, moderate with C#, and none with VBA ;p. But today, I decided to give it a go when I started repeating the same actions in Excell 2007 from...
  2. C

    Referencing a Range from within an Excel Add-in with a UDF

    I have created an excel add-in that contains a series of User Defined functions. The add-in consists of several worksheets that contain tables and single values, each of these has been referenced by a unique name i.e. "Table1-2" or "Value1-4". My UDF perform lookup's on these tables. All...
  3. S

    Select All Objects in Selection

    Hello, Anybody has a VBA-routine that selects all objects within a selection? i.e. it will select the objects in any random range I wish to select on my sheet. Thanks for your insights, Sige
  4. I

    Error 1004 And Range Question

    I'm trying to create a dynamic chart -- that allows a user to select the data they want displayed by selecting from a drop down menu. When I try to write the data source in a flexible way, though, I get a 1004 error. Here's the line that gives the error: ActiveChart.SeriesCollection(2).Values =...
  5. W

    Exclude range objects from range

    All, I have a tough one for you. Does anyone know if there is a way to create a range object that contains a known range, excluding other overlapping range objects. For example, let's say I have a pivottable called pvTable1 (dim pvTable1, set pvTable1 = ...). What I would like to do is...

Some videos you may like

This Week's Hot Topics

Top