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!

Search results for query: *

  • Users: 01Patrik
  • Content: Threads
  • Order by date
  1. 01Patrik

    XL: Error setting print area + multiple ranges

    Hi, I'm confused. I can't get XL to programatically set the print on a sheet to the mulitple ranges that I have as a print area on another sheet! Now normally I'd use With ActiveSheet.PageSetup .PrintTitleRows = "$1:$5" .PrintTitleColumns = "$A:$F"...
  2. 01Patrik

    XL: Error setting print area + multiple ranges by VBA

    Hi, I'm confused. I can't get XL to programatically set the print on a sheet to the mulitple ranges that I have as a print area on another sheet! Now normally I'd use With ActiveSheet.PageSetup .PrintTitleRows = "$1:$5" .PrintTitleColumns = "$A:$F"...
  3. 01Patrik

    Problem using replace in macro

    Hi, Have a problem using replace in a macro. I have no education at all in VB, everything i do is "self taught". This means that I rather include recorded code when possible, since I'm not a very competent code writer myself. The problem is that the recorded code doesn't work...
  4. 01Patrik

    Calculation errors in Excel 2000

    Hi, I have a user who is experiencing the strangest problem... She has a database which contains several hundreds of rows of data. Column "L" contains unique numbers. Sheet 2 (col "a") contains a number cells with the same kind of numbers as previously mentioned in sheet1!L:L. The main issue...
  5. 01Patrik

    Excel saving error

    Hi, I get the following error message when trying to save a template (kind of, anyway, my version is in Swedish): 'Excel cannot complete task with available resources. Choose a smaller amount af odata or close other applications' (OK button only) This is followed by an immediate new msgbox...
  6. 01Patrik

    DSUM

    Hi, Having problems with DSUM-functions. I'm successfuly using the function in a big template to calculate the differences between the sum bought and sold units of certain products, with data from two different (uncompatible) systems. The function used is the same in all cells (250 rows * 30...

Part and Inventory Search

Back
Top