View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
David Nebenzahl David Nebenzahl is offline
external usenet poster
 
Posts: 9
Default Request for VB to do something simple (insert text in a column ofcells)

I'm having a terrible time with methods, objects, properties, ranges ...
all making my head sorta spin.

What I want to do is pretty simple: turn the first column of cells into
the second one:

ceo -- XYZceo
abc -- XYZabc
123 -- XYZ123
vba -- XYZvba

and so on.

I know it might involve Insert("XYZ"), and I want it to be generalized
and operate on all the cells in a given column, so it would probably use
CurrentRegion.Cells, but I'm stumped.

(An extra twist is that the sheet would have a header row, so the text
should only be inserted starting with the 2nd row.)

Any light that could be shed on this would be much appreciated.