How do I create a loop to merge rows...

H

Helmut

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How do I create a loop to merge contents of rows 1-4 across column 2
Strip out certain rows that have merged cells 2
Border formatting row of cells 22
Take active cell value in for loop and offset based on another cellvalue for columns to offset 0
VBA code To Merge All .csv files into a single excel sheet (data start from row 11th) 2
Tax Form with Merge and Center 7
loop? 12
Merging row data in Column A has duplicate. 1

Top