Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]

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

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

Show all headers | View raw

slimeph@gmail.com brought next idea :
> I have the following code and I keep getting an error at line "Set timestamp 
> = Target.Offset(0, -3)". What seems to be the problem. What I would like to 
> do is whenever cells in column C is modified, corresponding column A will get 
> timestamped.
>
> TIA,
> kray
>
> ---
> Private Sub Worksheet_Change(ByVal Target As Range)
>         
>     'MsgBox Target.Address
>     Dim timestamp As Range
>     
>      
>     Set timestamp = Target.Offset(0, -3)
>     'MsgBox timeStamp.Address
>     
>     If timestamp.Value = "" Then
>         MsgBox "Nothing in there"
>         timestamp.Value = Now
>     Else
>         MsgBox timestamp
>     End If
>
> End Sub

Uh.., Column C minus 3 falls off the sheet since column A is -2!

-- 
Garry

Free usenet access at http://www.eternal-september.org
ClassicVB Users Regroup!
    comp.lang.basic.visual.misc
    microsoft.public.vb.general.discussion

Back to comp.lang.basic.visual.misc | Previous | Next — Previous in thread | Next 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