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 Quandan

  1. Quandan

    I can only paint with invisible paint!

    That's it! Problem solved. Thanks JavaBear! Marcel Kreijne Quandan - Steunpunt voor spreadsheetgebruikers (Quandan - Dutch supportsite for spreadsheetusers) http://www.quandan.nl
  2. Quandan

    I can only paint with invisible paint!

    Unfortunately I still have not solved the issue... as a matter of fact I have switched back to the program I upgraded from: Paint Shop Pro, which I start to appreciate more and more... Keep me posted if you get response from Corel! Thanks! Marcel Kreijne Quandan - Steunpunt voor...
  3. Quandan

    Better way to code the following

    Except for the fact that you implicitly assume that the range AresX does only contain 1 cell, I think there is not much efficiency to gain here... You might want to make your code run smoothly even if the range contains more than one cell by using Sheets("Sheet3").Range("AresX").Cells(1,1) or...
  4. Quandan

    Adding subtraction formula in code

    I'd say this should work: .Value = .Value - 1 Kind regards, Marcel Kreijne Quandan - Steunpunt voor spreadsheetgebruikers (Quandan - Dutch supportsite for spreadsheetusers) http://www.quandan.nl
  5. Quandan

    Excel projects and macros mess up

    Could it be that there is a reference created in your may19 workbook to the may18 workbook, or that you somewhere in your code hardcoded to do something in the workbook may18.xls? Kind regards, Marcel Kreijne Quandan - Steunpunt voor spreadsheetgebruikers (Quandan - Dutch supportsite for...
  6. Quandan

    Return zeros instead of #N/A on VLOOKUP

    Ranebow, Your formula should read: =if(isna(VLOOKUP(A3,AprilPivot!$D$5:$E$24,2,false)),0,VLOOKUP(A3,AprilPivot!$D$5:$E$24,2,false)) notice the second ) halfway the formula Kind regards, Marcel Kreijne Quandan - Steunpunt voor spreadsheetgebruikers (Quandan - Dutch supportsite for...
  7. Quandan

    I can only paint with invisible paint!

    I got a problem with Photo Paint 12: If I start the program, start a new file, select a color and click on the Paint Tool (the brush from the Toolbar)... NOTHING appears on my screen when I draw something on the canvas. PP does recognize it as a brush stroke though, since I am offered to repeat...
See more

Part and Inventory Search

Back
Top