Incorporating a macro in my BEx workbook

I have created a macro that works when it 1st runs or when filters are used but when I move in or take out columns it no longer refers to the correct columns. Is there a way to create a macro in Bex that will retain the columns. I tired to name the columns but this didn't work either