ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   How do I create a loop to merge rows... (https://www.excelbanter.com/excel-programming/376666-how-do-i-create-loop-merge-rows.html)

Helmut

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


All times are GMT +1. The time now is 05:23 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com