Object required error- looping through array- noobie

[sickel2]

I'm getting an object required error and I think it's coming from the for loop.

I'm trying to make an array out of the values of the cells in a range and then print them to make sure that I did it correctly.

Many thanks for any help. Should be a softy.

Please Login or Register  to view this content.

[p24leclerc]

First of all, you have to use CODE tags to publish any code on this forum (refer to forum's rules).
You insert the word CODE within square brackets at the beginning of your code and /CODE within square brackets at the end. You must change your thread in order to comply with forum's rules.

You have couples of errors in your code. try this one:

Please Login or Register  to view this content.

[Trebor76]

Cross-posted here

[royUK]

Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code. Posting code without them makes your code hard to read and difficult to be copied for testing. Highlight your code and click the # at the top of your post window. For more information about these and other tags, found here

[sickel2]

Thanks. The command to select all contiguous cells to the right Selection.End(xlToRight))
is going down so that my range is B8:#8 . Any ideas why it would go down instead of to the right?

[royUK]

This works for me

Please Login or Register  to view this content.

Note: no need to select B8

[sickel2]

This works. Thank you Roy.