Moderatori: Anthony47, Flash30005
Sub Salva()
Dim dati(150), cel As Range
Application.ScreenUpdating = False
Sheets("MODULO CONTESTAZIONE").Activate: Set Zona = Range("A2:E60")
riga = Range("D2")
For Each cel In Zona.Cells
cel.Select
If Selection.Locked = False Then i = i + 1: dati(i) = cel:
If i = 1 Then cc = cel.Address: ' MsgBox (cc)
Next
Sheets("Dati").Activate
For n = 1 To i
Cells(riga, n + 1) = dati(n)
Next
Sheets("Dati").Activate: Range(cc).Select
End Sub
Sub Leggi()
Dim dati(150), cel As Range
Application.ScreenUpdating = False
riga = Range("D2")
Sheets("Dati").Activate
For n = 1 To 150
dati(n) = Cells(riga, n + 1)
Next
Sheets("MODULO CONTESTAZIONE").Activate: Set Zona = Range("A2:E60")
riga = Range("D2")
For Each cel In Zona.Cells
cel.Select
If Selection.Locked = False Then
i = i + 1: cel = dati(i): ' Selection.Interior.ColorIndex = 20
End If
Next
End Sub
If Selection.Locked = False Then i = i + 1: dati(i) = cel.address
riga = Range("D2")+1
Sub Salva()
Dim dati(150), cel As Range
Application.ScreenUpdating = False
Sheets("MODULO CONTESTAZIONE").Activate: Set Zona = Range("A2:E65")
riga = Range("D2") + 1
For Each cel In Zona.Cells
cel.Select
If Selection.Locked = False Then i = i + 1: dati(i) = cel:
If i = 1 Then cc = cel.Address: ' MsgBox (cc)
Next
Sheets("Dati").Activate
For N = 1 To i
Cells(riga, N + 1) = dati(N)
Next
Sheets("Dati").Activate: Range(cc).Select
End Sub
Sub Leggi()
Dim dati(150), cel As Range
Application.ScreenUpdating = False
riga = Range("D2") + 1
Sheets("Dati").Activate
For N = 1 To 150
dati(N) = Cells(riga, N + 1)
Next
Sheets("MODULO CONTESTAZIONE").Activate: Set Zona = Range("A2:E65")
riga = Range("D2")
For Each cel In Zona.Cells
cel.Select
If Selection.Locked = False Then
i = i + 1: cel = dati(i):
End If
Next
End Sub
Sub Istruzione()
Range("d2").Select
With Selection.Validation
.InputTitle = "asd"
.InputMessage = ":"
End With
End Sub
If Sheets("dati").Cells(Rows.Count, 2).End(xlUp).Row > Range("D2") Then
riga = Sheets("dati").Cells(Rows.Count, 2).End(xlUp).Row + 1
Range("D2") = riga - 1: Beep
Else: riga = Range("D2") + 1
End If
Sub Leggi()
Dim dati(150), cel As Range
Application.ScreenUpdating = False
' riga = Range("D2") + 1 ' come era inizialmente
If Sheets("dati").Cells(Rows.Count, 2).End(xlUp).Row > Range("D2") Then
riga = Sheets("dati").Cells(Rows.Count, 2).End(xlUp).Row + 1
Range("D2") = riga - 1: Beep
Else: riga = Range("D2") + 1
End If
' inserito da IF fino a qui consiglio di Anthony
Sheets("Dati").Activate
For N = 1 To 150
dati(N) = Cells(riga, N + 1)
Next
Sheets("MODULO CONTESTAZIONE").Activate: Set Zona = Range("A2:E65")
riga = Range("D2")
For Each cel In Zona.Cells
cel.Select
If Selection.Locked = False Then
i = i + 1: cel = dati(i): ' Selection.Interior.ColorIndex = 20
End If
Next
End Sub
If Sheets("dati").Cells(Rows.Count, 2).End(xlUp).Row < Range("D2") Then
Torna a Applicazioni Office Windows
Inserire dati filtrati da 2 file ad un terzo file Autore: Ricky0185 |
Forum: Applicazioni Office Windows Risposte: 14 |
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 |
Visitano il forum: Nessuno e 60 ospiti