senker
08-21-2015, 01:54 PM
Hi Everyone,
Is it possible to do CTRL + SHIFT + DOWN in a Macro?
I've been search all over the internet and videos and I can't find a straight answer for various number of rows.
VBA I have now:
Sub q()
'
' q Macro
'
' Keyboard Shortcut: Ctrl+q
'
ActiveCell.Range("A1:AD1").Select
Selection.Copy
Range(Selection, Selection.End(xlDown)).Select
ActiveCell.Range("A1:AD12").Select
ActiveSheet.Paste
Selection.End(xlDown).Select
End Sub
Is it possible to do CTRL + SHIFT + DOWN in a Macro?
I've been search all over the internet and videos and I can't find a straight answer for various number of rows.
VBA I have now:
Sub q()
'
' q Macro
'
' Keyboard Shortcut: Ctrl+q
'
ActiveCell.Range("A1:AD1").Select
Selection.Copy
Range(Selection, Selection.End(xlDown)).Select
ActiveCell.Range("A1:AD12").Select
ActiveSheet.Paste
Selection.End(xlDown).Select
End Sub