Hi all fellow Excelers!
I need a helping hand with some VBA specifically relating to formatting a new sheet that has been created. I would like the top row to be bold and have a simple filter applied, see the below section of the script where I've been attempting it:
I've been able to text wrap the text in each cell and sort the horizontal and vertical alignment, I just can't make row 1 bold and apply filter to row 1. The sheet that the data comes from is titled "Investigations", and based on some user inputs, it copies it to a new sheet titled "My Investigations"
Any assistance would be awesome!
Cheers,
Mike
I need a helping hand with some VBA specifically relating to formatting a new sheet that has been created. I would like the top row to be bold and have a simple filter applied, see the below section of the script where I've been attempting it:
VBA Code:
Sheets("Investigations").Select
ActiveWindow.SelectedSheets.Visible = False
Selection.AutoFilter
Selection.WrapText = True
Selection.HorizontalAlignment = xlLeft
Selection.VerticalAlignment = xlVAlignTop
I've been able to text wrap the text in each cell and sort the horizontal and vertical alignment, I just can't make row 1 bold and apply filter to row 1. The sheet that the data comes from is titled "Investigations", and based on some user inputs, it copies it to a new sheet titled "My Investigations"
Any assistance would be awesome!
Cheers,
Mike