penultimate sheet

**max_max** · 08-03-2014, 05:19 AM

Hello,
there is a function that I excel at the end of the penultimate leaf selection changed?
This:

Sheets ("Sheet1"). Select

select only sheet1, but I want the penultimate sheet changed, which can be Sheet5, or Sheet3 etc ...
I hope I explained.
Thank you,
max_max
---------------------------------------------------------------------------------------------------------------
Ciao,
c'è una funzione che alla chiusura di excel mi selezione il penultimo foglio modificato?
Questo:

Sheets("Foglio1").Select

seleziona solo foglio1, ma io vorrei sul penultimo foglio modificato, che può essere foglio5, oppure foglio3 ecc...
Spero di essermi spiegato.
Grazie,
max_max

**Andy Pope** · 08-03-2014, 05:23 AM

Select one from last sheet.

Sheets(sheets.count-1).select

**max_max** · 08-03-2014, 06:57 AM

Thanks for your help Andy Pope.
No, the formula:
Sheets (sheets.count-1). Select the workbook select the sheet 8 in the workbook.
Must be the penultimate sheet changed.
max_max
---------------------------------------------------------------------------------------------------------------
Grazie dell'aiuto Andy Pope.
No, la formula:
Sheets(sheets.count-1).select nel workbook seleziona il foglio 8 nel workbook.
Deve essere il penultimo foglio modificato..
max_max

**Andy Pope** · 08-04-2014, 06:25 AM

standard code module

Public gLastSheetChanged(1 To 2) As Worksheet

Thisworkbook code module

Private Sub Workbook_SheetChange(ByVal Sh As Object, ByVal Target As Range)

    If Not gLastSheetChanged(1) Is Nothing Then
        Set gLastSheetChanged(2) = gLastSheetChanged(1)
    End If
    Set gLastSheetChanged(1) = Sh
        
End Sub

gLastSheetChanged(2) contains reference to penultimate sheet or Nothing if only 1 sheet changed.

**patel45** · 08-04-2014, 09:48 AM

My solution

Dim n As Integer
Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As Boolean)
Sheets(n).Select
End Sub
  
Private Sub Workbook_SheetDeactivate(ByVal Sh As Object)
n = Sh.Index
End Sub

penultimate sheet

LinkBack

Thread Tools

Rate This Thread

Display

Hybrid View

penultimate sheet

Re: penultimate sheet

Re: penultimate sheet

Re: penultimate sheet

Re: penultimate sheet

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Return penultimate value in a range

[SOLVED] Penultimate Value in Column

[SOLVED] Return penultimate value in a range

reverse lookup - last value & penultimate value

Penultimate, Second Value in a range

Bookmarks

Bookmarks

Posting Permissions