Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.newusers
|
|||
|
|||
![]()
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? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Simple problem, simple formula, no FUNCTION ! | Excel Worksheet Functions | |||
Simple IF problem | Excel Discussion (Misc queries) | |||
Simple problem | New Users to Excel | |||
another simple problem... | Excel Worksheet Functions | |||
Simple problem | Excel Discussion (Misc queries) |