Declare first row as header for VBA

[saschmeling]

Hi,

I am working with VBA and automating a spreadsheet that we do. We import and SSRS report into Excel, then perform certain tasks on it. However for one of the lines, it is giving the following error:

Microsoft Excel Cannot determine which row in your list or selection contains column labels, which are required for this command.

Is there a way in VBA to set Row 1 as a header row?

Thanks in advance,
Scott

 

[shg]

What do you see that message in response to?

 

[saschmeling]

Here's the code I am running at that time:

<cells.subtotal groupby:="2," function:="xlSum," totallist:="Array(2," 6,="" 9,="" 12="" _

Cells.Subtotal GroupBy:=2, Function:=xlSum, TotalList:=Array(2, 6, 9, 12 _
        ), Replace:=True, PageBreaks:=False, SummaryBelowData:=False

Thanks</cells.subtotal>

 

[shg]

Try

Application.DisplayAlerts = False
' your code
Application.DisplayAlerts = True

 

[saschmeling]

Try

Application.DisplayAlerts = False
' your code
Application.DisplayAlerts = True

Thanks will try.

 

[Fazza]

Likely a simple format of the headers will be adequate. That is often used within the spreadsheet to identify headers. Please try

cells.rows(1).font.bold = true

Or maybe some color too (for the header row only)

regards

post script : obviously I've assumed the headers are in row 1 of the worksheet

 

[s hal]

The display alerts will just bypass you having to say its okay to continue - the message you get looks like a halt error that won't let you continue by using the suggested code. Did you make whatever this macro is by use of the macro recorder? It seems to me that your file structure is different now than when you recorded a macro (the pasted code reeks of macro recorder!).

My guess is that one of your columns is now lacking a heading and excel isn't sure what to do with it...