Search results for query: *

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

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...

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...

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

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...

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...

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...