Excel 2007 not picking up Calculations as part of table

[eoinymc]

Hi,

I have a question that is tough to explain, but I'll try my best.

I have a sheet called "Data" & this is a SQL query that I pull using VBA (Rows A:J). I then do some calculations in VBA in Row K (Change from € to $).

When I run this macro, my Excel 2007 doesn't show column K as part of the table (i.e. the column is white and doesn't take the format of the table).

However, when a colleague of mine runs the macro, column K formats as part of the table...

I need it to be part of the table because I do some autofiltering on it in another macro and because column K is not part of the table, it won't let me autofilter the specified range.

It was working just fine for me until Friday and it just seemed to change!!

Does anyone know any settings or reasons this may happen?

It is quite annoying!

If you need any more information, please let me know.

Regards,

Eoin

 

[sahild05]

try creating a column k before running the macro by typing in a dummy value for the first row and then clearing it. perhaps the macro is sidestepping the auto-column-detect feature?

 

[Andrew Poulsom]

Possibly, look under Excel Options|Proofing|AutoCorrect Options and make sure that 'Include new rows and columns in table' is checked on the 'AutoFormat As You Type' tab.

 

[eoinymc]

Andrew, you really are an MVP!

Thanks for the help..strange that it was working last week and I didn't touch this option and it stopped working!

Anyway, thanks for the help!

Eoin