Object doesn't support this property or method error

[BillRobPV]

Frustrated with VBA help. A line of code like cells(rowno,"F").cut seems to
run just fine, but cells(rowno,"E").paste gets the error "Object doesn't
support this property or method". I can accept this "negative" error, but
how can I look at a list (in VBA help) of properties or methods that the
object DOES support. I realize this is a "newbie" kind of question. Sorry
about that. TIA.

 

[Dave Peterson]

I can do this in xl2003's VBA help.

Search for: Range Property
Scroll down the list and click on the "Range property" item

Then click on the:
Range property as it applies to the Application, Range, and Worksheet objects.
link

Then click on "range" in the:
Returns a Range object that represents a cell or a range of cells.
link

You'll be able to choose all the properties and all the methods using the links
at the top of the page.

======
Once you're more familiar, you can use:

Dim r as range
then type
r.
(include the dot)

You'll see the helpful intellisense pop up that shows all the properties and
methods you can use.

This is one of the best reasons to declare your variables using the correct
type.

 

[Bernie Deitrick]

Bill,

And, specifically, a range object doesn't support the paste method ;-)

One good way to find out what can and cannot work is to use the macro
recorder. But the way that I've found most helpful when I want to explore
the methods and properties is to look for a file named

vbaxl10.chm
or
vbaxl11.chm
or
vbaxl9.chm

When you open that, you can view objects, properties, methods, events, and
programming concepts.

Bernie

 

[BillRobPV]

Thank you gentlemen. I especially appreciate the quick response.