LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
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
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How to create copy & paste loop--rows to new sheets MFR Excel Programming 0 October 25th 06 07:50 PM
How to create adress list so can mail merge and create labels? adecocq Excel Discussion (Misc queries) 2 October 25th 06 12:32 AM
Merge two rows into one, then merge into mailer? tavat Excel Worksheet Functions 0 May 24th 06 07:52 PM
A loop to merge cells based on a value tschultz[_3_] Excel Programming 0 August 24th 05 07:50 PM
How do I create a For loop within a For loop? Linking to specific cells in pivot table Excel Programming 2 January 24th 05 08:05 AM


All times are GMT +1. The time now is 09:34 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"