Pete
09-12-2008, 02:56 AM
see attached workbook
Hi Experts
Ok here is the sequence keep the current function of the macro the same which is:
1. hide all 100& in column G
2. delete column header with Text 41
3. Highlight row 1 in yellow and adjust text to fit into column width.
4. and freezepanes column g (between f and g)
5. active window gridlines = false....
keep all the above in the macro NOW the following
6. from column G row 2 remove all border lines right, left, top, bottom etc......
7. NOW as shown in th eworksheet explain place a border around any number or text cell in the range g2:until the end of the worksheet...
i hope this is clear..........
Hi Experts
Ok here is the sequence keep the current function of the macro the same which is:
1. hide all 100& in column G
2. delete column header with Text 41
3. Highlight row 1 in yellow and adjust text to fit into column width.
4. and freezepanes column g (between f and g)
5. active window gridlines = false....
keep all the above in the macro NOW the following
6. from column G row 2 remove all border lines right, left, top, bottom etc......
7. NOW as shown in th eworksheet explain place a border around any number or text cell in the range g2:until the end of the worksheet...
i hope this is clear..........