Merge & Center across cells when row is a unknown/variable

[Kime]

I am bringing in raw data and after massaging it, I am formatting headers but I am having difficulty with the vba to select columns a through d when the rows are going to be a variable on a daily basis. After selection, I want the data merged & centered across A through D. Any suggestions or help will be greatly appreciated.

 

[Joe4]

Welcome to the Board!

A piece of advice - don't used merged cells, they are an atrocity that cause all sorts of issues with things like sorting and VBA.
Use the "Center Across Selection" formatting option, as described here: Tom’s Tutorials For Excel: Using Center Across Selection Instead of Merging Cells – Tom Urtis

So, regarding the VBA code, how exactly do you want this to work?
Are you going to be pre-selecting the rows that you want to apply it to?
Are you going to be selecting columns A-D, or do you want it to do that automatically for the rows you have pre-selected?

Or is there some logic that can be used to dynamically determine which rows to apply this to?

 

[Kime]

Welcome to the Board!

A piece of advice - don't used merged cells, they are an atrocity that cause all sorts of issues with things like sorting and VBA.
Use the "Center Across Selection" formatting option, as described here: Tom’s Tutorials For Excel: Using Center Across Selection Instead of Merging Cells – Tom Urtis

So, regarding the VBA code, how exactly do you want this to work?
Are you going to be pre-selecting the rows that you want to apply it to?
Are you going to be selecting columns A-D, or do you want it to do that automatically for the rows you have pre-selected?

Or is there some logic that can be used to dynamically determine which rows to apply this to?

I got it figured out. Thank you Joe4