Errors with Ranges

[NatalieEC]

Hello,

I am sorry to always be asking about ranges... I keep getting an error that says "method range of worksheet object failed". It is the line that says Set Vbr... I am so confused because I have never had this problem before when dealing with ranges.

If anyone can help me out, I'd greatly appreciate that. Thanks!

Please Login or Register  to view this content.

[Norie]

When using Range on it's own you need to use the column letter, not the column number.

If you want to use the number use Cells with Range.

Please Login or Register  to view this content.

[HaHoBe]

Hi, NatalieE,

Range expects a Column like A and not the number as the first argument, use Cells instead and try

Please Login or Register  to view this content.

Ciao,
Holger

[HaHoBe]

Hi, Norie,

sorry: no preview available at present so I merely posted the same code only hours later.

Holger

[NatalieEC]

Thank you so much everyone!

I did use a line before where I used the column number, and it worked. I must have set something up differently. I am still learning

[NatalieEC]

Now I have a new error! Why can't I set vbr in a while loop?

Please Login or Register  to view this content.