Hi there
I have an Auto open Macro that runs another macro called Bouns...
the auto open macro runs perfectely the Bouns code...
my problem is: I want the Bouns macro proceeds working if an intege
is entered into the range("F19:F74"), otherwise exit subs i.e. if a
integer is entered else where in the sheet then exit Boun
sub................
I only know, if an integer is entered into a specifi
column.........................
PHP code
-------------------
Sub Auto_Open()
Sheet5.OnEntry = "Bouns"
End Sub
Sub Bouns()
Dim myrange As Range
Set myrange = Range("F20:F74")
With ActiveCell
If .Column = 6 Then
my code
end with
End Su
-------------------
:confused
--
helmekk
-----------------------------------------------------------------------
helmekki's Profile:
http://www.excelforum.com/member.php...nfo&userid=693
View this thread:
http://www.excelforum.com/showthread.php?threadid=27177