Hi all,

I am pretty new to VBA.

I am basically trying to do some formatting in VBA.
I cannot specify the ranges because it changes everytime.This is what I am trying to do:
I have column headings in row 6 and it has data present from Col A to Col S. But this range changes all the time.I am trying to create border around the cols A to Cols S and inner borders also.My problem is how to specify this dynamic range.
Below is what I am trying to do.



I would really appreciate any help.

Thanks