Recent content by sandoztek

I will have a look at this VBScroll. thank you for helping.

It has always been enabled. I just went once into the Control Panel/Mouse app to set the minimum nb of lines /wheel step.

Office 97

When I split a vba code window, the mouse scroll works only in the lower window. how to mouse scroll in the upper part of the window as well?

my code did contain a comma in the Diff function, I was just absentminded when I put a minus sign in my text

I 'll take your code, which is nicer/neater than mine. This said, it doesn't work either, ..... just because when I re installed Windows etc.., I forgot ....to modify the Regional Settings (environment is in French, but I use Excel & VB, VBA in English UK). It's all right now, both my code &...

I have been using the code below to substract 2 given dates to get days: nbDays = DateDiff("d",date2 - date1) date1 example : "2009-03-06" ( 06 march ) date2 example : "02Feb09" I have date2 = Left(date2, 2) & "-" & Mid(date2, 3, 3) & "-" & Right(date2,2) then date2= Format(date2...

Alt-enter is a manual operation, I want it to be done by program, when the cell is filled with the string. Also, I DON'T WANT the wrap, just a single text line. ................ ok, I found the problem : I did use the right property .WrapText = False but it must be applied to the cell AFTER it...

I want a text string put into a cell to be displayed in a single line, that is extended to the right, without the cell width being modified. Currently, the width remains unchanged but the cell height is increased to contains the whole text. Which format must be applied to this cell to have this...

Yes, my code checks the format is 2 3 2 (ddmmmyy)

Your solution is the one I finally reached too (I used "-" instead of " "). Thank you

I have the string date "23Mar08" . Can it be easily translated into a formated one (for arithmetic operations)

Capito, the problem was the (ambiguous)Destination.

Ok, fine now, I'll try not to forget the advice. It's a subtelty I haven't seen documented yet... Thank you !

In a piece of code using web queries I normally use the F1 sheet But when I started a similar code using another F2 sheet I have an error I do not understand: Please explain why the first set works and the second one doesn't, I get "argument or procedure call incorrect (error 5)" Both sheets...