Change code to ActiveSheet

[rajeshn_in]

Hi friends,

I got a code from http://www.vbaexpress.com/forum/arch...p/t-13260.html website

this code applying for all sheets in a workbook. I want to apply only active worksheet. Please change code as Active Sheet mode

And Line going to across sheet. Can we control that line in a range, like I have a data in Range A1:K114, So will come A to K column only.

Please Login or Register  to view this content.

[Norie]

Try this.

Please Login or Register  to view this content.

[rajeshn_in]

Thank you norie,

And Line going to Total row. Can we control that line in a range, like I have a data in Range A:K, So line will come A to K column only.

[rajeshn_in]

Thank you norie,

And Line going to Total row. Can we control that line in a range, like I have a data in Range A:K, So line will come A to K column only.