Print current page with active cell with VBA code Excel 2010

Hi,

I have a workbook contains some worksheets, and every worksheet have multiple pages. I want to print only one page that contains active cell. Normally, i have to identify the workbook page then input the number twice as in “pages # to #” with the Print command. It is just waste of time.
I have fount the code as below. But it gives Error "Expected: line number or label or statement or end of statement" on this line "If .HPageBreaks(iRow).Location.Row <= activerow="" then="" goto="" vertical="" span="">"

If someone could help me to resolve the error problem, it'd be appreciated.

Many thanks in anticipation.

Please Login or Register  to view this content.