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...

This Week's Hot Topics

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top