Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations biv343 on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. smart89

    How to get the print area with excel vba?

    rmikesmith, Thanks for reply. Printing the current page containing active cells is the origina purpose of mine. I could do this if I know the range of print area and the active cells.This is useful when I modify some cells after printing out all pages.For nothing remains but to print the...
  2. smart89

    How to get the print area with excel vba?

    no,it didn't work. did you define the print area before running? I didn't want to define print area setup manually.The print area was defined by excel automatically.thanks again for reply.
  3. smart89

    How to get the print area with excel vba?

    thank combo and rmikesmith.but the used range was different to print area.the used range was "B3:B133" and the print area was "A1:I162" in my case.How can i get the range "A1:I162"?
  4. smart89

    How to get the print area with excel vba?

    the print area was not set ,but it displayed 8 pages when print preview.How to get the area without setting print area? in addition, another question for help.How to print the current page containing active cells? thanks again.
  5. smart89

    How to get the print area with excel vba?

    thanks. but it couldn't work.the code "Worksheets("Sheet1").PageSetup.PrintArea" returned empty string ("") only.
  6. smart89

    How to get the print area with excel vba?

    the print area displayed A1:I216 and J1:S216 after print preview,I want to get the area with VBA code ,how can i get it? thanks

Part and Inventory Search

Back
Top