![]() |
#7
|
||||
|
||||
![]()
Okay, you've slightly misunderstood my quesiton. Let me explain what I was driving at....
In my example I used Code:
With Sheet1 In your code you used this instead: Code:
With Data So you need to either use the worksheet's codename like I did (you can see the codename in the VBA IDE in the project explorer window - see my attachment) or you need to get a reference to the worksheet via the Worksheets collection using either the worksheet's name or it's index (eg With Worksheets("Data"). Does that make sense? |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
Sorting by certain criteria | randenius | Excel | 2 | 06-11-2012 02:18 AM |
![]() |
jpotter2 | Word | 3 | 03-22-2011 02:07 PM |
Challenge!! Need help though. (Conditional formatting) | knuckles70 | Excel | 2 | 02-05-2010 12:24 PM |
![]() |
lax828 | Excel | 3 | 01-07-2010 11:28 AM |
Challenge: Get Custom Form to Show up in Reader Pane in 2007 | JohnGG | Outlook | 0 | 08-21-2009 05:44 AM |