Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Macro question, Copy-Paste
hi, I am trying to pick columns from a keyboard short cut with macro located
under a General Module..? but I get an: Invalid use of Me keyword. is there a way to make this work? thanks. Sub Paste2() 'alt-/ (slash) Dim M2 As String M2 = Range("M2") Dim N3 As String N3 = Range("N3") Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _ :=False, Transpose:=False ActiveWindow.SmallScroll Down:=190 ActiveCell.Offset(190, 0).Select If Not Intersect(Me.Range(M2), .Cells) Is Nothing Then With Me.Cells(.Row, N3).Select '.Offset(0, 0).Select End With End If 'With Me.Cells(.Row, N3).Select 'Range(ActiveCell, ActiveCell.Offset(190, 0)).Copy End Sub |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Copy and Paste Question | Excel Discussion (Misc queries) | |||
Yet another copy/paste macro question | Excel Discussion (Misc queries) | |||
Copy/Paste Question | Excel Discussion (Misc queries) | |||
Copy/Paste question | Excel Worksheet Functions | |||
Copy Paste Question | Excel Discussion (Misc queries) |