Search results for query: *

Common sense isn't all that common.... not my quote, but it sure is true Be Alert, America needs more lerts

6 o'clock High Be Alert, America needs more lerts

Pretend it's in your rearview mirror Be Alert, America needs more lerts

[bigsmile] and the flatirons hanging from the earlobes... Be Alert, America needs more lerts

Hudson and Landry.....I loved those guys.....the Weird Kingdom was great....thanks for the memories.... Be Alert, America needs more lerts

I knew a lady named Penny Nichols Be Alert, America needs more lerts

you might have better luck posting this in the VBA Visual basic for applications (Microsoft) forum.... Ernest Be Alert, America needs more lerts

It's a bit confusing on how you have your data set up...if it is set like this Col A Col b Jan North Jan North Feb North Mar South ... then a pivot table with Column labels being Date(col A) and row Labels being Region(Col b) and values being Count of Date(Col A) that...

I'm probably off base but is there a NAT Table somewhere that is mucking up the system? Ernest Be Alert, America needs more lerts

if Lionelhill is correct about how you have you data set up you can use VBA to loop through the rows and collect them in an array and then do whatever you want to with said array...if you go that route then it would make sense to repost this in the forum that Skip suggests... Ernest Be Alert...

if you truly want a VBA Solution then there a VBA group just for that.... VBA Visual Basic for Applications (Microsoft)... a repost into that group would be a good idea.... I'm also looking into a solution... Ernest Be Alert, America needs more lerts

you're welcome Sir Ernest Be Alert, America needs more lerts

this may not be easy but it seems to work on the data set you created and some corner cases I added... =CONCATENATE(LEFT(E3,1),TEXT(MID(E3,2,FIND("^",E3,1)-2),"00"),"^",TEXT(MID(E3,FIND("^",E3)+1,FIND("'",E3)-FIND("^",E3)-1),"00"),"'",RIGHT(E3,1)) this assumes your data is in column E and the...

Nope....excellent question though...I have talked with the IT folks here and they are going to upgrade the PC with one that has office 2007...everything I find about this says it's a bug in Excel...some people even have cases open with Microsoft and are still waiting for an answer...I should get...

Source file is created using the following: OS: XP PRO Sp3 - all updates completed Office 2003 - all updates completed Toad for DA is being launched by the windows scheduler and creating a file on the network. The file is being opened by (Managers Laptop): OS: Win7 - all updates completed...

I have seen issues that during a push, network issues caused a corrupt install...I'm not sure the diagnostic/repair would catch it....just a thought...and doing a re-install doesn't take much time....but it might be better to do it local instead of a push... Be Alert, America needs more lerts

so did the IT dept push this remotely on to your computer or did they come around with CD's?...I'm just wondering if a re-install might be the ticket....I'm remembering old Microsoft humor, like "MicroSoft has detected mouse movement, Please re-boot"...HTH Be Alert, America needs more lerts

Hi Skip -- I'm in agreement with Zelgar...here is a thought though...is anyone else in the company having the same issue?...are you the only one who uses a PERSONAL.xlsb? Be Alert, America needs more lerts

I have never tried this in the Windows world, but in the old UNIX days I'd have run it background mode and that would close the window but keep the process running. Try putting an "&" at the end of the line...this may not help, but give it a shot... Be Alert, America needs more lerts

Hi Skip should there be a doublequote before the B$2 to match the one after the $3? Sheets("Sheet3").Range(B$2:S$3") ^ Ernest Be Alert, America needs more lerts