Thread: copy cell from sheet 2 to sheet 3 macro
View Single Post
 
Old 02-17-2010, 09:20 PM
slipperyjim slipperyjim is offline Windows XP Office 2007
Novice
  
Join Date: Feb 2010
Posts: 2
slipperyjim is on a distinguished road
Default copy cell from sheet 2 to sheet 3 macro
hi all, new to macroing for word 07. i am trying to accomplish running a macro from a check box that copies the contents of cell 2 in column one of my table to column 1 cell 11 on page 3. i have found some code on the net, can anyone help me modify it to suit?

p.s. i need the code to step to the next free cell.

Code:
Sub TransferOfData()
'
' TransferOfData Macro
'
Dim NextCol As Integer
  NextCol = Sheets(2).Cells(1, Columns.Count).End(xlToLeft).Column + 1
   Sheets(2).Range("L19:L26").Copy
    With Sheets(3).Cells(11, NextCol)
     .PasteSpecial Paste:=xlPasteValues
    End With
End Sub
this looks suspiciously like excel code, again, totally new to word coding.

thanks for any help.
Reply With Quote