Method 'Range' of object '_worksheet' failed

[wilro85]

I'm trying to select a range that will be changing by column. I'm not sure why my syntax isn't working.

What I've got:

Please Login or Register  to view this content.

I'm using the above code for debugging purposes. The column number will be incremented in a loop (I.E. 3->4->5...)

What I want is something like this:

Please Login or Register  to view this content.

Are there any ideas for why this isn't working?

[Richard Schollar]

You either need to access the address property of the cells object, or you need to fully qualify the Cells objects and avoid string conactenation altogether. It should work if you write like this:

Please Login or Register  to view this content.

or like this (assumes a ChartSheet isn't active):

Please Login or Register  to view this content.

[wilro85]

Accessing the address worked fine. Thank you very much.