johnsharda
Gebruiker
- Lid geworden
- 2 jul 2017
- Berichten
- 23
bestand doet het wel maar de macro word zo wel erg lang, iemand een oplossing hiervoor?
Sub facturen()
Sheets("huurders").Select
Range("A4").Select
Selection.Copy
Sheets("factuur").Select
Range("B10").Select
ActiveSheet.Paste
Range("a1:e71").Copy
Sheets("print").Select
Range("a65535").End(xlUp).Offset(1, 0).Select
Selection.PasteSpecial Paste:=xlPasteAllUsingSourceTheme, Operation:=xlNone _
, SkipBlanks:=False, Transpose:=False
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False
'als er lege rij is
Sheets("huurders").Select
If Range("a5") = "" Then
Sheets("print").Select
ActiveWindow.SelectedSheets.PrintPreview
End If
Range("A5").Select
Selection.Copy
Sheets("factuur").Select
Range("B10").Select
ActiveSheet.Paste
Range("a1:e71").Copy
Sheets("print").Select
Range("a65535").End(xlUp).Offset(1, 0).Select
Selection.PasteSpecial Paste:=xlPasteAllUsingSourceTheme, Operation:=xlNone _
, SkipBlanks:=False, Transpose:=False
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False
'-------------------------------------------------------
Sheets("huurders").Select
If Range("a6") = "" Then
Sheets("print").Select
ActiveWindow.SelectedSheets.PrintPreview
End If
Range("A6").Select
Selection.Copy
Sheets("factuur").Select
Range("B10").Select
ActiveSheet.Paste
Range("a1:e71").Copy
Sheets("print").Select
Range("a65535").End(xlUp).Offset(1, 0).Select
Selection.PasteSpecial Paste:=xlPasteAllUsingSourceTheme, Operation:=xlNone _
, SkipBlanks:=False, Transpose:=False
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False
'-------------------------------------------
Sheets("huurders").Select
If Range("a7") = "" Then
Sheets("print").Select
ActiveWindow.SelectedSheets.PrintPreview
End If
Range("A7").Select
Selection.Copy
Sheets("factuur").Select
Range("B10").Select
ActiveSheet.Paste
Range("a1:e71").Copy
Sheets("print").Select
Range("a65535").End(xlUp).Offset(1, 0).Select
Selection.PasteSpecial Paste:=xlPasteAllUsingSourceTheme, Operation:=xlNone _
, SkipBlanks:=False, Transpose:=False
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False
'-------------------------------------------
Sheets("huurders").Select
If Range("a8") = "" Then
Sheets("print").Select
ActiveWindow.SelectedSheets.PrintPreview
End If
Range("A8").Select
Selection.Copy
Sheets("factuur").Select
Range("B10").Select
ActiveSheet.Paste
Range("a1:e71").Copy
Sheets("print").Select
Range("a65535").End(xlUp).Offset(1, 0).Select
Selection.PasteSpecial Paste:=xlPasteAllUsingSourceTheme, Operation:=xlNone _
, SkipBlanks:=False, Transpose:=False
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False
'-------------------------------------------
Sheets("huurders").Select
If Range("a9") = "" Then
Sheets("print").Select
ActiveWindow.SelectedSheets.PrintPreview
End If
Range("A9").Select
Selection.Copy
Sheets("factuur").Select
Range("B10").Select
ActiveSheet.Paste
Range("a1:e71").Copy
Sheets("print").Select
Range("a65535").End(xlUp).Offset(1, 0).Select
Selection.PasteSpecial Paste:=xlPasteAllUsingSourceTheme, Operation:=xlNone _
, SkipBlanks:=False, Transpose:=False
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False
'-------------------------------------------
Sub facturen()
Sheets("huurders").Select
Range("A4").Select
Selection.Copy
Sheets("factuur").Select
Range("B10").Select
ActiveSheet.Paste
Range("a1:e71").Copy
Sheets("print").Select
Range("a65535").End(xlUp).Offset(1, 0).Select
Selection.PasteSpecial Paste:=xlPasteAllUsingSourceTheme, Operation:=xlNone _
, SkipBlanks:=False, Transpose:=False
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False
'als er lege rij is
Sheets("huurders").Select
If Range("a5") = "" Then
Sheets("print").Select
ActiveWindow.SelectedSheets.PrintPreview
End If
Range("A5").Select
Selection.Copy
Sheets("factuur").Select
Range("B10").Select
ActiveSheet.Paste
Range("a1:e71").Copy
Sheets("print").Select
Range("a65535").End(xlUp).Offset(1, 0).Select
Selection.PasteSpecial Paste:=xlPasteAllUsingSourceTheme, Operation:=xlNone _
, SkipBlanks:=False, Transpose:=False
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False
'-------------------------------------------------------
Sheets("huurders").Select
If Range("a6") = "" Then
Sheets("print").Select
ActiveWindow.SelectedSheets.PrintPreview
End If
Range("A6").Select
Selection.Copy
Sheets("factuur").Select
Range("B10").Select
ActiveSheet.Paste
Range("a1:e71").Copy
Sheets("print").Select
Range("a65535").End(xlUp).Offset(1, 0).Select
Selection.PasteSpecial Paste:=xlPasteAllUsingSourceTheme, Operation:=xlNone _
, SkipBlanks:=False, Transpose:=False
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False
'-------------------------------------------
Sheets("huurders").Select
If Range("a7") = "" Then
Sheets("print").Select
ActiveWindow.SelectedSheets.PrintPreview
End If
Range("A7").Select
Selection.Copy
Sheets("factuur").Select
Range("B10").Select
ActiveSheet.Paste
Range("a1:e71").Copy
Sheets("print").Select
Range("a65535").End(xlUp).Offset(1, 0).Select
Selection.PasteSpecial Paste:=xlPasteAllUsingSourceTheme, Operation:=xlNone _
, SkipBlanks:=False, Transpose:=False
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False
'-------------------------------------------
Sheets("huurders").Select
If Range("a8") = "" Then
Sheets("print").Select
ActiveWindow.SelectedSheets.PrintPreview
End If
Range("A8").Select
Selection.Copy
Sheets("factuur").Select
Range("B10").Select
ActiveSheet.Paste
Range("a1:e71").Copy
Sheets("print").Select
Range("a65535").End(xlUp).Offset(1, 0).Select
Selection.PasteSpecial Paste:=xlPasteAllUsingSourceTheme, Operation:=xlNone _
, SkipBlanks:=False, Transpose:=False
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False
'-------------------------------------------
Sheets("huurders").Select
If Range("a9") = "" Then
Sheets("print").Select
ActiveWindow.SelectedSheets.PrintPreview
End If
Range("A9").Select
Selection.Copy
Sheets("factuur").Select
Range("B10").Select
ActiveSheet.Paste
Range("a1:e71").Copy
Sheets("print").Select
Range("a65535").End(xlUp).Offset(1, 0).Select
Selection.PasteSpecial Paste:=xlPasteAllUsingSourceTheme, Operation:=xlNone _
, SkipBlanks:=False, Transpose:=False
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False
'-------------------------------------------
Bijlagen
Laatst bewerkt: