Great - but can we do it twice?!
Sun, 31 Aug 2008 15:54:02 -0700
Hi,
Your code below is perfect for me:
Private Sub Worksheet_Change(ByVal Target As Range)
On Error GoTo ws_exit:
Application.EnableEvents = False
If Not Intersect(Target, Me.Range("A1:A10")) Is Nothing Then
With Target
If .Value <> "" Then
Range("P1").Value = Format(Now, "dd mmm yyyy hh:mm:ss")
End If
...
|
Excel files open with Acrobat
Sun, 31 Aug 2008 13:52:00 -0700
I just got a new computer & had to reinstall my Office 2007, Windows, Adobe,
etc. For some reason now when i open an Excel file, it comes up blank, but
if i click on the Acrobat tab it opens & then i can click on the Home tab &
comes fine. Why is this happening & how do i stop this? I just want my file
to ...
|
excel macro mail send
Sun, 31 Aug 2008 22:30:37 +0200
Hello,
I'm using this vb macro code for sending mail.
---------------------------------------------------------------
Sub mailto_Selection()
Dim Email As String, Subj As String, cell As Range
Dim response As Variant
Dim msg As String, url As String
Email = "" 'create list below
Subj = ...
|
Recherche Astuces Seek Astuces
Sun, 31 Aug 2008 10:33:35 +0200
Mes Dames Messieurs Bonjour
Je voudrais savoir comment faire pour recopier une ligne complète et non le
tableau d'un tableau Excel vers un autre tableau suivant la valeur ou l'indication
contenu dans une cellule de cette ligne.
Question traduite avec WORD et je ne comprends que le Français.
Merci de votre ...
|
"Not Responding" for HOURS
Sun, 31 Aug 2008 00:51:01 -0700 (PDT)
My Excel 2007 spreadsheet has been "Not Responding" for HOURS.
I can hear the hard drive spinning (at various speeds) but, on the PC,
the green activity light (indicating that data is being written to or
read from the hard drive) has been flashing very infrequently.
I don't want to lose the changes I've made ...
|
Autofill a series from the name box?
Sat, 30 Aug 2008 17:48:56 -0700
If I want to autofill a series of values from 1 to 10, using the autofill
handle is the easiest way to do it. But if I want to autofill 1 to 1000,
that's a bit more tedious with the autofill handle. Is it possible to do it
from the name box? I've been told it can be done but I can't figure it out.
Help do ...
|
Determine Intersection of 2 lines using Excel VBA
Sat, 30 Aug 2008 15:56:39 -0700 (PDT)
Y values - I have y-values in 2 rows of my spreadsheet, say A5:W5 and
A10:W10.
X values - The x-values are common to both rows, and listed in A2:W2.
I would like to use vba to determine the intersection of these y-
values, and determine where on the y-axis and x-axis do the lines
intersect.
I would like ...
|
|
|
AVERAGE formula with a twist
Sat, 30 Aug 2008 15:54:27 -0700
Hello -
I need to average a range of cells B2:Y31. Normally, I'd use the formula
=AVERAGE(B2:Y31)... easy enough.
The twist is that I need to average that range of cells, BUT any cell that
has a value less than 1 or more than 900 cannot be used in the calculation.
These values are considered invalid for ...
|
Euro symbol
Sat, 30 Aug 2008 23:21:31 +0100
I have a spreadsheet and I have formatted the cells to give me the euro
symbol (previously uk sterling) so that is ok.
However within the spreadsheet I have a text box, how do I get the euro
symbol within it?
--
Rent a villa in Turkey
http://www.freewebs.com/turkeyre ...
|
Compare columns
Sat, 30 Aug 2008 13:17:36 -0700 (PDT)
How do I determine whether the data in COL A exists COL B?
How do I determine whether the data in COL A does NOT exist in COL B?
...
|
