ashokbioinfo
01-26-2012, 10:02 AM
Hi everyone,
In the Information sheet, I want to clear the contents of column (border, fill color) after any words and then encounter blank cells(here column K onwards).
Always see that column are in dynamic range. That means there is a possibility of adding new column or vice versa.
Can anybody help me
If possible how can I print the output into pdf format (R1:dynamic range) using VB. In pdf header/footer must be there like if 10 pages are there, hea/footer should be 1/10, 2/10, 3/10,..............
In the Information sheet, I want to clear the contents of column (border, fill color) after any words and then encounter blank cells(here column K onwards).
Always see that column are in dynamic range. That means there is a possibility of adding new column or vice versa.
Can anybody help me
If possible how can I print the output into pdf format (R1:dynamic range) using VB. In pdf header/footer must be there like if 10 pages are there, hea/footer should be 1/10, 2/10, 3/10,..............