Search results

/*This should do as you require*/ /*objRange is your Range com-handle*/ objRange = objSheet:Range(Firstcell , Lastcell). objRange:NumberFormat = "[$$-409]#,##0.00".

Glad to help :rolleyes:

I have a support program which runs constantly but sits minimized on the taskbar, when a new support call arrives i create a message box and restore the window to warn me, however, the message box and window are restored to their "normal window" state and left behind any active windows. I have...

Replace/Concat Character variables used to accumulate data in a loop can also cause this error, if the data accumulated exceeds the allocated size (32000 bytes), if you are accumulating a string variable that may exceed this limit, simply create a temp table with an index (to store the creation...

I would like to launch the outlook address book and return a list of selected email addresses, I am having a little trouble finding the correct com-objects, can any point me in the right direction or supply example code? Thanks!