Moderatori: Anthony47, Flash30005
Application.ScreenUpdating = Default '<<<<<<<<< aggiungere
Application.ScreenUpdating = True '<<<<<<<<< aggiungere
Application.ScreenUpdating = False '<<<<<<<<<< tua riga codice
Sub Ricerca()
Application.ScreenUpdating = False
Application.Calculation = xlManual
Cells(4, 28) = Cells(4, 11)
Cells(4, 30) = Cells(7, 4)
Cells(4, 6) = Cells(3, 6)
Cells(3, 28) = Cells(7, 2)
Worksheets("Foglio2").Select 'qui cambia visione foglio
F = Cells(1, 26)
FT = Cells(1, 1)
Range(Cells(3, 28), Cells(4000, 52)).Select
Selection.Clear
Worksheets("Foglio1").Select
V = Cells(4, 38)
Worksheets("Foglio2").Select
Cells(1, 31) = V
For X = 1 To FT - F
For Y = 5 To 24
If Cells(X + 1, Y) = V Then
Cells(X + 1, 28) = 1
End If
Next
Next
Worksheets("Foglio1").Select
Range("A1").Select
Application.Calculation = xlCalculationAutomatic
Application.ScreenUpdating = True
End Sub
Sub Ricerca()
Application.ScreenUpdating = False
Application.Calculation = xlManual
'.................................................... AGGIUNTE
Dim Ws1 As Worksheet, Ws2 As Worksheet
Set Ws1 = Worksheets("Foglio1")
Set Ws2 = Worksheets("Foglio2")
'.................................................... AGGIUNTE
Ws1.Cells(4, 28) = Ws1.Cells(4, 11)
Ws1.Cells(4, 30) = Ws1.Cells(7, 4)
Ws1.Cells(4, 6) = Ws1.Cells(3, 6)
Ws1.Cells(3, 28) = Ws1.Cells(7, 2)
' Worksheets("Foglio2").Select 'qui cambia visione foglio <<-------------- Cancellare
F = Ws2.Cells(1, 26)
FT = Ws2.Cells(1, 1)
Ws2.Range(Ws2.Cells(3, 28), Ws2.Cells(4000, 52)).Clear
' Selection.Clear
' Worksheets("Foglio1").Select <<-------------- Cancellare
V = Ws1.Cells(4, 38)
' Worksheets("Foglio2").Select <<-------------- Cancellare
Ws2.Cells(1, 31) = V
For X = 1 To FT - F
For Y = 5 To 24
If Ws2.Cells(X + 1, Y) = V Then
Ws2.Cells(X + 1, 28) = 1
End If
Next
Next
' Worksheets("Foglio1").Select <<-------------- Cancellare
Ws1.Range("A1").Select
Application.Calculation = xlCalculationAutomatic
Application.ScreenUpdating = True
Set Ws1 = Nothing
Set Ws2 = Nothing
End Sub
Application.ScreenUpdating = Default '<<<<<<<<< aggiungere
Application.ScreenUpdating = True '<<<<<<<<< aggiungere
Application.ScreenUpdating = False '<<<<<<<<<< tua riga codice
Application.ScreenUpdating = True '<<<<<<<<< Spostare qui
Application.ScreenUpdating = Default '<<<<<<<<< Spostare qui
Application.ScreenUpdating = False '<<<<<<<<<< tua riga codice
Torna a Applicazioni Office Windows
Inserire add.in nella barra di avvio veloce in excel 2003 Autore: Ricky0185 |
Forum: Applicazioni Office Windows Risposte: 4 |
Excel: problema con date se devo unirle a testi Autore: valle1975 |
Forum: Applicazioni Office Windows Risposte: 5 |
confrontare e evidenziare 2 fogli excel Autore: niccia |
Forum: Applicazioni Office Windows Risposte: 7 |
Visitano il forum: Nessuno e 23 ospiti