Error working with Range Object in VBA

[henryBukowski]

Apologies, this is purely amateur stuff:

The following code works:

Please Login or Register  to view this content.

However, when I try to add a single cell reference to MyRange, it returns an error. For example:

Please Login or Register  to view this content.

What am I doing wrong, or what am I not doing?

I've learnt a lot in the past weeks working with vba, but tiny things like this baffle me from time to time.

[AB33]

Please Login or Register  to view this content.

I think you can only have a row and column.

[ragulduy]

Far as I'm aware, you can't have more than two arguements when assigning a range. If you use Range("A1","F1"), this is the same as Range("A1:F1"), i.e. the two arguements define the opposite corners of the range. So Range("N41:N43","R41:R43") would give you Range("N41:R43"). I'm assuming you only want N41, N42, N43, R41, R42 and R43 and not the cells in between which would be:

Please Login or Register  to view this content.

Extending that to include T43:

Please Login or Register  to view this content.

[henryBukowski]

I'm always surprised when people reply to my cries for help!

That's excellent yudlugar - works perfectly now, and I've learnt something!