View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Helmut Helmut is offline
external usenet poster
 
Posts: 111
Default How do I create a loop to merge rows...

My appologies to you super users out there, but I'm stuck and could use some
help.

I have a spreadsheet that loads a text file for any given number of rows
across colums a:fg. I need to reserve the first four rows of this
spreadsheet for column headings which would be copied from another source..
Column by column I can selects rows 1-4 and manually format them. I can
repeat the process in VB code, column by column but this seems wasteful and
redundant. Is there anyway I can create a loop to select and format (merge
cells) for columns "a" to "fg"? Your help is greatly appreciated.
Helmut