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!

  • Congratulations bkrike 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. thanos54321

    Copying from a word table to an excel table with line breaks in 1 cell

    Hi, I couldn't find any threads containing this issue, and I'm very rusty on VBA at the moment, so I need some help. Specifically, I'm trying to select some text like that is, text including soft line breaks, in word, and copying to excel. The problem is, excel thinks the line breaks indicate...
  2. thanos54321

    Word: Problem integrating two documents with same styles

    Hi, I've recently created a styles and formatting setup for a document, and have been writing in two different files that have exactly the same setup. Part of the setup is the heading styles, which I've numbered and applied a certain length between the numbering and the heading text. This works...
  3. thanos54321

    Space for footnote too large after customizing styles

    Hi, you guys are my last hope, I've been trying to do a basic style setup that I want to use for several documents, such as headers, some captions, etc. Now, once I'm done with it all, I tried inserting a footnote at the end of the page. Between the footer and the footnote is about 1 cm, AND...
  4. thanos54321

    Accepting dialog boxes (NOT ignoring them) - how?

    Hi, I am currently testing an excel addin simulation program called crystal ball 7.1 (www.crystalball.com if you care), and I've encountered an annoying problem that I hope can be solved by VBA. Specifically, I am using some inputs for simulation that might be in conflict with each other. When...
  5. thanos54321

    ActiveSheet.Next.Select in a loop - how to abort without error?

    Hi all, I'm working on a code that runs through several sheets with the same code. In the end of the loop, there is a code like: ActiveSheet.Next.Select Obviosly, this will make the code crash with an error message when there are no more sheets. What I'd like the code to do is to end without...
  6. thanos54321

    Using find-function to search for something not there results in error

    Hi there, I have a question about the find-function in excel/vba. Basically, I'm just recording the find-function (the ctrl+f one, not some lookup function or whatever), and as a part of a larger sub, the find-function is called within VBA to search for some specific regional names in several...

Part and Inventory Search

Back
Top