View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Kevin Sprinkel Kevin Sprinkel is offline
external usenet poster
 
Posts: 14
Default Operating on a Selected Range

We have a macro that indents and inserts a hyphen onto
text, i.e., "Johnson" becomes " - Johnson". We would
like the macro rather than operate on a single cell to
cycle through each cell in the selected range.

I am also curious to know what Visual Basic method moves
the active cursor down one cell.

Thank you for the help.

Kevin Sprinkel
Becker & Frondorf