Search results for query: *

Look for an other job.

I am not a VBA espert, but I guess that you can execute a external program. Just execute rundll32 printui.dll,PrintUIEntry /y /n "printer" /q for setting the printer you wish as default. Print at the end of your macro just repeat again for re set the right one.

JohnGP, I am afraid that is do not work that way. I mean, if both condition are true I'll just have the sum of ALL data in the c6:c15 and not only the ones that respect the condition and if both condition are not meet I'll just hve nothing. Am I wrong?

Array formulas? What is that? Wow, I have to try...

I have the need of printing lots of different section of a drawing in lots of A4 sheets. There is a way to automatize this process? Using layouts maybe?

Disable it, it is far better downloading the .pdf and seeing them later with the reader. A good thing could be also use Ghostscript related programs to convert .pdf in other format like .html

it isnt free?

I found a good solution... Since month never overtook 12 and day never overtook 31 it is enough strip all the date in a single number, like this: E.G. 13/06/2004 is the date (cell a1) with the formula =year(a1)*10000+month(a1)*100+day(a1) become 20040613 easily usable for conditions :) in my...

I have to sum a column data when, not just one condition is met, but 2. In my case the year and the month of a date must equal to what I want. Is that possible?

Using Windows 2000 the best and easy way is makeing a starting script, a .bat file with the following commands: rd /s/q (your cookies folder) md (you cookies folder)\index.dat executed once (as startup script) will deactivate the index.dat file forever making a folder with the same name :)

err... no... I have to use only formulas. The conditional formatting do not help me...

May this helps? http://download2.citrix.com/files/en/products/nfr/ica/ica32t.exe

You can tranform ANY file you can print in .pdf. Install a "HP Color LaserJet PS" that print to "files". Download and install Ghostscript and Ghostgum (a gui for Ghostscript). Print the file using that virtual printer and it will create a .prn file. Using Ghostgum convert...

Does it exist? Or it is already possible do, only with formulas enlarge, colorize or shink cell?

I'll try to explain better... I have a long list of data and in the first column I have a date. 1/1/3 DATA DATA DATA ect. 2/1/3 DATA DATA DATA ect. 5/1/3 DATA DATA DATA ect. 5/1/3 DATA DATA DATA ect. 5/1/3 DATA DATA DATA ect. I made a formula that detects the change of the date alternating a 0...

Probably you have to make it by yourself... try HACI

I'd like to change a whole row background color if a cell value is odd or not. Is that possible?

Try HACI www.arbeit.ro/haci/ I used the free version that is already quite cool with simple hatchs, but if you need complex ones you should really buy it. It is not expensive and it works perfecly. Good luck.

Thanks everyone, as lots said, there is no need of traspose. But the idea of make a list of number and sort using them is quite good and worked perfecly. I'll try to make a macro that add a new row write in it the numbers, sorts colunms and delete the row. Eng tips ROCKS!

ivanlocke ideas seems good. Also pmover's one seems good... I'll try them both....