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 Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by arbeeone

  1. arbeeone

    Embedding Graphics in a VBA Macro

    The macro processes what is essentially timesheet data extracted from a corporate data base and then does a LOT of formatting! At the moment, it had been a local office initiative but the desire is to distribute it nationally to all other offices. Some of the output goes externally to customers...
  2. arbeeone

    Embedding Graphics in a VBA Macro

    Hi, What I'm wanting to do is create a macro which, in addition to formatting a data file, also prints the Company Logo at the top of the page. The problem is that once the macro is distributed, there would be no common source from which to import the graphics. So, is there any way to embed a...
  3. arbeeone

    String Manipulation

    Hi, I'm trying to manipulate a string of up to 40 characters in length which is basically a free-form entry although there are some basic 'standards' for data entry. I have the feeling I'm missing something very simple, but I want to be able to identify the first alpha character (i.e. A-Z only)...
  4. arbeeone

    Printing multiple, and different, sets of header rows

    I was trying to avoid going to multiple sheets if possible because the reports would themselves then have to be sorted, or it would require a potentially large number of print commands. Although there are three report 'types' as shown above, there are potentially many more than just 3 reports...
  5. arbeeone

    Printing multiple, and different, sets of header rows

    There is a single large input file coming into Excel which is being reformatted using VBA into 3 types of reports: a) detail b) first level summary (based on certain fields) and c) overall totals, plus some quite 'fancy' formatting that is required (colours etc). Each of the 3 types of report...
  6. arbeeone

    Printing multiple, and different, sets of header rows

    I'm wanting to repeat 4-5 header rows on each page (NOT Header/Footer) but also to change the Rows that are printed at different, known stages through the report when I force a Page Break. By using the .PrintTitleRows feature, I can print one set of header rows, but I can't see how to change it...
  7. arbeeone

    Inserting Multiple Rows in Excel using VBA

    Thanks Geoff, I'd tried 2 or 3 different combinations of concatenation but not that one! rsb
  8. arbeeone

    Inserting Multiple Rows in Excel using VBA

    I've tried this, but the problem is that the macro recorder gives specific row numbers (e.g. Rows("10:11") ) but I want to have them as variable names. I've tried Rows("r:r1") and Rows(r:r1) but neither seem to work. rsb
  9. arbeeone

    Inserting Multiple Rows in Excel using VBA

    Hi, I want to insert multiple rows into a worksheet using VBA. I can insert a single row using: Rows(r).Insert - where r is the row number But, Rows(r:r1).Insert (where r1 is the last row number) doesn't work. I've tried using the Cells method for the Range but this also gives me problems. I...
  10. arbeeone

    using sum function with vba

    Oooops, I've just tried the formula again only this time using [A1].Formula rather than [A1].FormulaR1C1 and the Sum code worked! - So thanks Skip!! However, I still have the problem with inserting rows, so I still need help there if possible. rsb
  11. arbeeone

    using sum function with vba

    Hi, I have the same basic question. I have tried the code as recommended above by Skip but when I run it in a macro, I am getting the formula come out as =SUM('S13':'S17') (these are the cells I want, but not in quotes). As a result, I'm getting #NAME? in the cell. Any suggestions? Also, I have...
See more

Part and Inventory Search

Back
Top