Recent content by bandit600

Manxster, When you say “all of a sudden”, could that have been about 6 days ago. Might they have been swapped? Also although I don’t have one of these devices myself, I thought keyboards and mice like this have some way of switching radio frequencies or whatever they use. bandit600

What version of Office? If its '97 I know of a way, but not if its any other version. bandit600

nfpk, It’s to do with computers storing everything in binary. In very simple terms, everything we see on screen is only a representation. To work on numbers, or anything else, the computer has to convert everything to binary, then do its calculations and then convert back to the representation...

Try this http://www.microsoft.com/officedev/articles/faceid.htm bandit600

You need to create a shortcut to that drive and put it in the Send To folder. The Send To folder in Win 98 is a sub folder of Windows. The Send To folder in Win 2k is a sub folder of the User in Documents and Settings. Afraid I don't know for other versions. bandit600

Pyrrhus, I developed a workbook in Excel 97 for distribution a while back and created a custom toolbar with a single button with a blank face. It was only obvious that it was there if you hovered over it. Clicking on it gave you a menu option to enter a password, entering the correct password...

Lee Count only counts numbers, so will ignore all the subtotals. The countif subtracts any non-subtotals that are 0. Is that what you are after? bandit600

Going back to the idea of using Text for the subtotals, you may be able to avoid VBA. In case there was any doubt, I didn’t mean formatting them as Text, as has been said in this forum many times, formatting doesn’t change what’s underneath. I’ve tried the following on some sample data and it...

I like to look at things from alternative perspectives. (Its just the way I am) Sometimes this works and sometimes I am way off the mark, as some of you may have noticed. There are always posts in this forum where people are trying to apply numeric functions on what turns out to be text. So why...

Nate, You could try =((NETWORKDAYS(D1,D2)-1)*9)+(HOUR(D2)-HOUR(D1))+((MINUTE(D2)-MINUTE(D1))/60) where D1 = Date 1 in your examples and D2 = Date 2 in your examples This is untested and doesn’t allow for holidays ( which I would put in a named range) bandit600

The original post could be ambiguous. Skip's post should solve one interpretation. But it could also be read as requiring to calculate the number of the week (in the year) from a given date, in which case the WeekNum function will do if installed. For instance Weeknum(Today()) returns 10...

Geoff, I found your post helpful, I can use this myself. Have a star on me. bandit600

Hmadyson, Keeping to similar lines, but doing away with the loop, you could try Sub MakeThisCellSpecialFormat() Dim FontSize As Integer With ActiveCell .Value = UCase(.Value) FontSize = .Font.Size ActiveCell.Characters(Start:=2).Font.Size = FontSize - 3 End With End Sub Would it...

Hmadyson, I would be interested if you would like to post your macro. Have you thought of assigning it to a custom button on your formatting toolbar? bandit600

This works for me in ’97. You can put the following in an auto open macro. Application.DisplayAlerts = False This will turn off all alerts so you may want to reset it to true later. bandit600