Table column have amount, worksheet hidden

Originally Posted by mangesh.mehendale

Try using regular Range instead of using Table like .. say your Salary Col is in Range C4:C50 the use ...

Please Login or Register  to view this content.

Also its appearing that you have not mention variable for Range "Slr" VBA cant identify the Slr as Range unless it is declared try below code...

Please Login or Register  to view this content.

I need the dynamic range. The data already is created as Table. Thus I use table with header name to set the range.

How to add in dynamic range by using table's header?

Originally Posted by mangesh.mehendale

Try using regular Range instead of using Table like .. say your Salary Col is in Range C4:C50 the use ...

Even I use the range, the worksheet also hidden for counta = 0.