davidhall80
Well-known Member
- Joined
- Jul 8, 2006
- Messages
- 663
I have a column with the word "Year To Date" in row 14. However each week, it moves over one column as new data comes in. I need the previous 8 columns put into a group. In the example below. My "Year To Date" column was column N and then I grouped columns F:M. Can I put in something like this in VB. Whatever cell contains the words "Year to Date", group the previous 8 columns? Thanks
Columns("F:M").Select
Selection.Columns.Group
Range("A1").Select
Columns("F:M").Select
Selection.Columns.Group
Range("A1").Select