Include 2 sheets in code loop?

**Aland2929** · 08-19-2013, 10:50 AM

I am using the following code to change the charts in the sheet "DashBoardOne". I want to include the sheet "DashBoardTwo" in the code. Can someone please advise how I change line 3 to include the additional sheet?

Please Login or Register  to view this content.

Thanks in advance.

**AB33** · 08-19-2013, 11:05 AM

May be

Please Login or Register  to view this content.

**Aland2929** · 08-19-2013, 11:11 AM

Thanks for your reply. I receive the following error when using that code?
Error: Object does not support this property or method

**AB33** · 08-19-2013, 11:18 AM

Try this one

Please Login or Register  to view this content.

**Aland2929** · 08-19-2013, 11:25 AM

Thanks very much. That works.

**wlugo13** · 08-19-2013, 04:21 PM

--I apologize. After re-reading my post doesn't apply---

@AB33
Would you be able to tell me where something like that would fit in my situation?

I'm using a UserForm to enter information into a single worksheet. There is a lot of repetitive code here. It would be beneficial to me if I could separate it into 3 or 4 different worksheets.

Most of this came from piecing together other forum posts and Google solutions.

Thanks for any help you can give.

I truncated some of the code...

Please Login or Register  to view this content.

Include 2 sheets in code loop?

LinkBack

Thread Tools

Rate This Thread

Display

Include 2 sheets in code loop?

Re: Include 2 sheets in code loop?

Re: Include 2 sheets in code loop?

Re: Include 2 sheets in code loop?

Re: Include 2 sheets in code loop?

Re: Include 2 sheets in code loop?

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Macro needs amendment to include loop

Code To Find and Offset works on first sheet but won't loop to other sheets

Resolved >>> Adjust code to include sorting employee sheets a-z?

[SOLVED] Adapt code to loop through sheets

include empty sheets

Bookmarks

Bookmarks

Posting Permissions