Set Ranges Throwing Unknown Error

[Mordred]

Hi all,

The following code is a part of a function that I am working on.

Please Login or Register  to view this content.

This code worked up until I added

Please Login or Register  to view this content.

and now for some reason stops at

Please Login or Register  to view this content.

I can't for the life of me see why! Also, the error prompt is a none descriptive message with a big X on the left side and the number 400 on the right. If anyone can see why I would appreciate your comments. Until then, I guess debugging each line of code for my whole project may be needed.

Thanks

[Leith Ross]

Hello Mordred,

You are trying to directly assign range values where one range is horizontal and the other is vertical.

Please Login or Register  to view this content.

[Mordred]

Hi Leith and thanks for pointing out something that I should have seen.