View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.newusers
mrmnz mrmnz is offline
external usenet poster
 
Posts: 14
Default Really simple macro problem - I bet!

I have the following text in 3 separate cells ie. C16, C17, C18

Esk Valley
Hastings
New Zealand

I wrote a macro to get it looking like this (using Paste Special/Transpose),
starting with Esk Valley in F16 (and it works!)

Esk Valley Hastings New Zealand

BUT when I go to the next set of cells to run the macro again, it just
repeats the macro using the cells already recorded:

Keyboard Shortcut: Ctrl+j
'
Range("C16:C18").Select
Selection.Copy
Range("F16").Select
Selection.PasteSpecial Paste:=xlPasteAll, Operation:=xlNone,
SkipBlanks:= _
False, Transpose:=True
End Sub

How do I tell the macro to change to C20:C22 and move this text to C20?