Right-click on the Sheet1 tab and "View Code"

The copy/pasting is done with event code.

I would add one more line to the code after Target.Select

Application.CutCopyMode = False


Gord Dibben MS Excel MVP

On Wed, 17 Jan 2007 12:51:01 -0800, Lewis0205NC
wrote:

This is exactly what I was wanting to do but how did you paste the values in
the other columns?

"galimi" wrote:

I have created a spreadsheet named quickPaste.xls in
http://www.HelpExcel.com/examples
--
http://HelpExcel.com




"Lewis0205NC" wrote:

I am curious if there is an easier way to paste an exact value into an
adjacent column. Currently, I am using the paste special function but this
is tedious? Is there a keyboard shortcut to do this? For example, column 1
has a value which is derived from a formula (x * 12 months) and I want
columns 2-6 to have the same value as column 1. If you copy and past the
value, it will update the formula for that column. Any advice?