Set Ranges Throwing Unknown Error

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

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.

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