Error while selecting a range

[rakeshplb]

I am using the following statement to return to first sheet after completing a 'For Next' loop. This throws an error.

Please Login or Register  to view this content.

This works when I modify this to -

Please Login or Register  to view this content.

I have reinstalled Excel and rebooted several times but still this happens. What's wrong and what should I do? Thanks!

[romperstomper]

Nothing is wrong. You cannot select a range on a sheet that is not active, so you have to activate that sheet first.
You could almost certainly rewrite your For...Next loop so that it doesn't change the active sheet when it runs though.

[rakeshplb]

Thanks romperstomper.
This looks bit strange not to be able to directly select a range. This may be Excel's fault. Many thanks to you!