|
|
#3
10-25-2015, 09:02 AM
|
|||
|
|||
You don't say what the problem is but probably Sheet1 and Sheets("Sheet4") being the same sheet could have something to do with it.
In the VBA environment have a look at the Excel Objects for sheets. The name on the left is the code name of the sheet and the name in brackets is the tab name. Need to decide which you are going to use and be consistent. 
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Vba to Filter data | saurabhlotankar | Excel Programming | 5 | 05-29-2015 06:07 AM |
 Extract Excel Data from Chart in Word
|
cillianmccolgan | Word | 1 | 08-15-2014 01:42 AM |
|
Extract data from web - Take a long time
|
edneco | Excel Programming | 11 | 06-28-2014 05:54 PM |
|
How to Extract key data from word
|
iliauk | Word | 3 | 11-08-2013 04:37 PM |
Windows 7 64bit 
Office 2010 64bit
Threaded Mode