formula for columns

[mcsparron]

hi all, can you help please, i am exporting a table from access to excel , this is working ok , what i am now trying to do it just place a top border only on the columns, the number of columns can change as the table can change before export , i have a DIM set up to count the number of columns, [Dim col as integer] this also works , the code i have been using is
.Range("b2:h2").Borders(xlEdgeTop).LineStyle = XlLineStyle.xlContinuous
but i need the value in col to reflect what column to end the borders on, so if col is 5 then the formula would change to ("b2:h2"), (column 5),
if col is 10 then the formula would be ("b2:j2"), (column 10), how do i change the second part of the formula in vba to reflect what is stored in col? .
please remember i am a newbie and this might need explaining as to how any solution works

[nankw83]

Hi mcsparron,

Try below code ...

Please Login or Register  to view this content.

[mcsparron]

thanks nankw83, works a treat

[nankw83]

Glad to help & thanks for the added Rep.

If that takes care of your question, please take a moment & mark this thread as [SOLVED] from the Thread Tools above your first post