Object Issue

**darbar82** · 06-15-2013, 11:15 PM

Hi,

Think i have an object issue below as the loop code previously worked. i've attached a word document showing the screen print and have scoured the internet but simply cannot remove the error
The CurrentMth Value shows up as teh correct string when i hover above it.
Any pointers appreciated

Please Login or Register  to view this content.

**MarvinP** · 06-15-2013, 11:26 PM

Hi,

Try this:

Set TargetWS = ActiveWorkbook.Sheets(CurrentMth)

**abousetta** · 06-16-2013, 12:38 AM

You need to set worksheets and range objects (like Marvin said)

Please Login or Register  to view this content.

abousetta

**darbar82** · 06-16-2013, 03:32 AM

Thanks. This worked great!

**darbar82** · 06-16-2013, 03:33 AM

Thanks. That's the first time I've seen the colons used in code too which i think is easier on the eyes than double lines.

**abousetta** · 06-16-2013, 05:16 AM

Glad I could help. You will often see the colon used an If/ Else/ End If statement with something like "Else:". Other times I find it nice to use the colons is when we loop.

For example:

Please Login or Register  to view this content.

Hope this helps.

abousetta

P.S. If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.
Thanks.