PDA

View Full Version : Delete blank row after words and print in pdf



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,..............

ashokbioinfo
01-28-2012, 06:21 AM
Can anybody help me in finding the solution for my above query. I don't want pdf