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 Mike Lewis 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. pit263

    count shapes

    thanks a lot for the help. I really appreciate it. the program does work. But as you mentioned, it only looks at the last cell though. What i would like to have it do, is knowing how many pages to print and then ending in the printpreview mode. This is something i still can not figure out...
  2. pit263

    count shapes

    hm, sorry about that. My bad. Is it possible to change the code a bit and then use it for Excel?
  3. pit263

    count shapes

    it is a VBA code. I am trying to program it in excel, so far without any kind of success :(
  4. pit263

    count shapes

    no, i've already noticed that, but that couldn't have been the problem because the line "for i = 1 to .Paragraphs.Count" is marked yellow. So i figured that VBA can't read it for some unknown reason Thanks a lot again for your help Peter
  5. pit263

    count shapes

    it says "run time error '424' object required" and offers me to debug Since i don't know too much about these error messages, i don't know what that means
  6. pit263

    count shapes

    thanks for the help macropod, when i tried to run the program it told me that something is wrong and marks the For i = 1 To .Paragraphs.Count line Do you know why that is?
  7. pit263

    count shapes

    I am trying to figure out how to tell vba to count all the shapes in a document. Afterwards i would like it to select the last (furthest to the right) shape and depending on what page it is, print that many pages. If anyone could help me here, i would really appreciate it. I know it can't be to...

Part and Inventory Search

Back
Top