mkk
08-21-2008, 08:34 AM
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
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