|
|
#3
01-22-2017, 12:04 PM
|
|||
|
|||
Thanks for the reply, that does fix the problem of the spaces in the sheet name, but not the apostrophe. But that's close enough for now, thankyou.
SubAddress:="'" & ws.Name & "'" & "!" + Found.Address 
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
 Open an existing sheet by clicking on a cell in a master sheet
|
darbybrown | Excel | 3 | 09-12-2016 05:12 PM |
| Populate sheet 3 with data from sheet 1 and sheet 2 | speck | Excel Programming | 0 | 01-14-2015 07:54 AM |
| Adding names to sheet for printing | WV8VFD | Excel | 4 | 12-01-2013 11:02 PM |
| How to enter names in Resource Pool/names | pstein | Project | 1 | 03-26-2012 07:37 AM |
| Word to Excel hyperlinks and spaces | gak | Word | 1 | 09-14-2008 08:38 AM |
Windows 7 32bit 
Office 2013
Threaded Mode