Groups > comp.lang.basic.visual.misc > #1286

Re: Run-time error '1004': Application-defined or object-defined error

From	"Auric__" <not.my.real@email.address>
Newsgroups	comp.lang.basic.visual.misc
Subject	Re: Run-time error '1004': Application-defined or object-defined error
Date	2012-07-10 23:24 +0000
Organization	A noiseless patient Spider
Message-ID	<XnsA08CA735D7667auricauricauricauric@88.198.244.100> (permalink)
References	(3 earlier) <jthiho$2u2$1@dont-email.me> <XnsA08C6664F269auricauricauricauric@88.198.244.100> <jtholc$873$1@dont-email.me> <XnsA08C7465B128auricauricauricauric@88.198.244.100> <071e486f-3c56-47b3-8091-bab494f95cc0@googlegroups.com>

Show all headers | View raw

"slimeph" wrote:

> On Tuesday, July 10, 2012 1:26:07 PM UTC-5, Auric__ wrote:
[snip]
>> What I would do would be more like this:
>>
>>   Private Sub Worksheet_Change(ByVal Target As Range)
>>     Dim cell As Range
>>     For Each cell In Target
>>       If cell.Column = 3 Then
>>         With Cells(cell.Row, 1)
>>           If .Value = "" Then
>>             MsgBox "Nothing in there"
>>             .Value = Now
>>           Else
>>             MsgBox .Value
>>           End If
>>         End With
>>       End If
>>     Next
>>   End Sub
>>
>> Also, I agree with your pointing the OP to the Excel group.
>
> Thanks the above code works. I am just wondering about the error I'm
> getting but that will be for another day. Better read something about
> this topic.

No clue. Just when I think I have it figured out, I find that something else 
makes it error out again. The code I posted, either the above, or what I just 
posted a few minutes ago in reply to Garry ("GS"), will work without error.

-- 
I hate Linux because it makes me type "man mount".

Back to comp.lang.basic.visual.misc | Previous | Next — Previous in thread | Find similar

Thread

Run-time error '1004': Application-defined or object-defined error slimeph@gmail.com - 2012-07-09 11:27 -0700
  Re: Run-time error '1004': Application-defined or object-defined error GS <gs@somewhere.net> - 2012-07-09 18:13 -0400
    Re: Run-time error '1004': Application-defined or object-defined error slimeph@gmail.com - 2012-07-10 05:36 -0700
      Re: Run-time error '1004': Application-defined or object-defined error GS <gs@somewhere.net> - 2012-07-10 11:42 -0400
        Re: Run-time error '1004': Application-defined or object-defined error "Auric__" <not.my.real@email.address> - 2012-07-10 17:03 +0000
          Re: Run-time error '1004': Application-defined or object-defined error GS <gs@somewhere.net> - 2012-07-10 13:27 -0400
            Re: Run-time error '1004': Application-defined or object-defined error "Auric__" <not.my.real@email.address> - 2012-07-10 18:26 +0000
              Re: Run-time error '1004': Application-defined or object-defined error GS <gs@somewhere.net> - 2012-07-10 16:28 -0400
                Re: Run-time error '1004': Application-defined or object-defined error "Auric__" <not.my.real@email.address> - 2012-07-10 23:10 +0000
                Re: Run-time error '1004': Application-defined or object-defined error GS <gs@somewhere.net> - 2012-07-10 21:21 -0400
              Re: Run-time error '1004': Application-defined or object-defined error slimeph@gmail.com - 2012-07-10 15:26 -0700
                Re: Run-time error '1004': Application-defined or object-defined error "Auric__" <not.my.real@email.address> - 2012-07-10 23:24 +0000

csiph-web