|
|
|
|
#1
08-21-2012, 06:54 AM
|
|||
|
|||
Changed the code to
Code:
Private Sub Workbook_BeforeClose(Cancel As Boolean)
Dim wkbk1, wkbk2 As Workbook, wksheet1, wksheet2 As Worksheet, intIndex As Integer
'set the source workbook
Set wkbk1 = Application.Workbooks("Trial1.xlsm")
'set the source worksheet
..................
 
|
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| sheet 2 data highlight in sheet 1 | gsrikanth | Excel | 1 | 04-21-2012 06:25 PM |
| how to go 75 sheet | gsrikanth | Excel | 5 | 01-17-2012 11:24 PM |
| Adding columns in specific rows only | mhays | Excel | 5 | 01-17-2012 09:13 AM |
 Construct a summary sheet by summing up from one or more than one sheet.
|
PRADEEPB270 | Excel | 1 | 11-04-2011 03:46 AM |
| copy cell from sheet 2 to sheet 3 macro | slipperyjim | Excel Programming | 1 | 02-18-2010 01:31 AM |
Windows 7 64bit 
Office 2007
Hybrid Mode