I have the win and place markets logging to two seperate worksheets.
I have worksheet_change code for each sheet but the code for one sheet is also changing the 2nd sheet. Does anybody know how I keep the processing for eacj sheet seperated?
VBA help required
Moderator: 2020vision
3 posts
• Page 1 of 1
VBA help required
by methodman » Tue Jan 15, 2008 2:22 pm
- methodman
- Posts: 119
- Joined: Thu Mar 09, 2006 11:06 am
by Ian » Tue Jan 15, 2008 2:37 pm
Specify in full the cells to be used eg.
Workbooks("Book1").Sheets("Sheet1").Range ("A1")
Workbooks("Book1").Sheets("Sheet1").Range ("A1")
- Ian
- Posts: 834
- Joined: Sat Nov 19, 2005 8:35 am
- Location: Birmingham
by methodman » Fri Jan 18, 2008 6:06 pm
Thanks Ian
That put me on the right track
I put Sheets("sheetname").Select before each macro call and I think its done the trick.
That put me on the right track
I put Sheets("sheetname").Select before each macro call and I think its done the trick.
- methodman
- Posts: 119
- Joined: Thu Mar 09, 2006 11:06 am
3 posts
• Page 1 of 1
Who is online
Users browsing this forum: No registered users and 105 guests