Thread: Copy cell to another cell using Macro
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Gord Dibben Gord Dibben is offline
external usenet poster
  
Posts: 22,906
Default Copy cell to another cell using Macro
I like that bit Jerry.

Much shorter than the version I came up with.

Gord

On Sat, 20 Oct 2007 17:58:00 -0700, JLatham <HelpFrom @
Jlathamsite.com.(removethis) wrote:

Target.Offset(0, 2) = Target.Offset(0, 1)

Reply With QuoteReply With Quote