Simple copy macro

[Optitron]

This should be pretty simple. I need a macro that copies specific cells so I can paste them into another program.

I want to be able to select a cell in a specific row to select that row of data.
Then click a button.
The macro will copy the cells from that selected row. From column AM to BB.
Then once it's copied all i have to do it click on my other program and click paste.

[emmamaki]

Optitron,
I hope this few lines of code would help you.
In case you also need to open the application you intend to paste the data to, just add this line Call shell ("Path\application.exe")

Example: Call shell ("c:\windows\notepad.exe") there after hit edit paste the data should be in your desired applicaton.

Sub Macro1()
'
' Macro1 Macro
' Macro created by 1/5/2007 by optitron
'
'
Range("AM:BB").Select
Selection.Copy

End Sub

[Optitron]

Thank you but that code copies the entire column. My problem is I need to copy the cells in column AM:BB of the row I selected.

Optitron,
I hope this few lines of code would help you.
In case you also need to open the application you intend to paste the data to, just add this line Call shell ("Path\application.exe")

Example: Call shell ("c:\windows\notepad.exe") there after hit edit paste the data should be in your desired applicaton.

Sub Macro1()
'
' Macro1 Macro
' Macro created by 1/5/2007 by optitron
'
'
Range("AM:BB").Select
Selection.Copy

End Sub

[jasoncw]

Try this:

Please Login or Register  to view this content.

[Optitron]

Perfect, it worked. Thank you.

Try this:

Please Login or Register  to view this content.