Search:

Does this do what you want?


Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If Not Intersect(Range("B3:H14"), ActiveCell) Is Nothing Then
Range(Cells(3, ActiveCell.Column),...

Right-click the sheet tab and enter or copy the following code:


Private Sub Worksheet_SelectionChange(ByVal Target As Range)
Range("D3") = Range("A" & ActiveCell.Row)
End Sub

Hi. How...

Does this help?

http://exceltips.vitalnews.com/Pages/T0183...n_a_Column.html

Matthew,

P9:P39 contains the numbers that would be summed if all the other conditions are true...effectively 1 x 1 x 1 times whatever number is in the relevant row in P.

Brett

I've found a Google Group posting that states IE 5.2 was for OS X, and 5.1.7 was as high as OS 9.x went. The post has a link to download version 5.1.7, so I'm going to give that a try next time...

Thanks, Hans. Version 5.0.6 is the version they're currently using. Evidently, there's some sort of encoding or something that this version isn't capable of that 5.2 was. I can't remember exactly...

Hi. Does anyone have any idea where I can go to download Outlook Express 5.2 for the Mac OS9.x? I have in-laws with an old mac who aren't willing to upgrade computers or operating systems.
...

Thanks - it was in the slide master.

That was exceedingly frustrating...Thanks again for the answer!

Hello. I'm having problems with a presentation. I have a slide show that I've modified from someone else's file. Some of these slides used to have bulleted lists on them, but I've taken all the...

Other than the fact that it's saved as a flash file, is there any advantage to using this service over just taking your 20-30 pictures and making your own animated gif?

-Brett

something like this would do the job. What's your definition of cheap?

http://www.geeks.com/details.asp?invtid=3506SASP-BLK&cat=CSE

If you change calculation to 'manual' before opening the workbook, the #REF shouldn't show up.

I think your user is confusing Autorecover with AutoSave.

From the MS Support site:

AutoSave
Microsoft Excel 97 and Microsoft Excel 2000 include an AutoSave feature. You can customize this...

When you double click it in Word, you should be able to go to Insert>Name>Define and change it there.

replace with a '+ instead of just a + will do what you want

Rudi,

It looks like this is held in a file called wmpvis.dll in the folder C:Program FilesWindows Media Player. I'm still on version 9...don't know much about version 10. I could email this dll...

I'm using Excel 2000 SP3 - that's how it works on my machine, too (at least in the page setup dialogue). The zoom values are retained when switching from fit to and adjust.

If you set the pagesetup to Adjust to instead of Fit to in the code and then pull the percentage and change pagesetup back to Fit to, are you able to pull the percentage and keep the original Fit To...

I just picked up Premiere Elements 2.0 and Photoshop Elements 4.0 yesterday. One thing to be aware of before you begin the 1.2 GB download of the trial software is that Premiere Elements 2 won't...

Differences between Professional and other versions can be found here http://www.microsoft.com/office/editions/p...ctionality.mspx

This origin makes some sense, though I can't imagine drug addicts actually researching this to coin the term themselves...

(after John Jones, the British physician who first described opiate...

If you have Windows XP you can do this for free with Windows Movie Maker.

How about this formula, starting in B2 in your example and copied down to the end of your range...

=IF(OR(A2=A1, A2=A1+1), "", "missing")

Oops, I read this again and I think I misunderstood what you were after. Sorry.

could you fill in the blanks with one of the methods from <post#=460,022>post 460,022</post: > and then concatenate the row data and sort on the concatenated value?

Example attached.